Userform dropdown for a calendar view

[Karthik Thandapani]

Hi,

My requirement is to allow users to multi-select weeks or a month as a whole by showing a userform dropdown or a calendar.

a. Userform to show 52 financial week as a dropdown or monthly calendar
b. Enable collapse & expand button
c. Enable user to multi-select weeks or on a month so all the pertaining weeks get selected
d. Capture selected weeks in a column as I already tied that to filter data

File attached for your reference. Please help.

 

[jeffreyweir]

see the reply I left at http://www.chandoo.org/forum/threads/vba-code-snippet-to-activate-a-pivot-slicer.18539/