VBA code snippet to activate a pivot slicer

[Karthik Thandapani]

Hi,

Can anyone please provide me with a code snippet by which I activate a pivot slicer or bring a slicer to focus please?

Thanks,
Karthik

 

[jeffreyweir]

Hi Karthik. Suggest you just fire up the macro recorder and select a slicer, and see what it spits out.

I've written quite a bit on slicers, pivotfields, and syncing pivots over at www.dailydoseofexcel.com recently. e.g.
http://dailydoseofexcel.com/archives/2014/07/10/what-caused-that-pivottableupdate-episode-iv/
http://dailydoseofexcel.com/archives/2014/08/05/slicers-and-slicercaches/



Out of curiosity, what are you actually trying to achieve?

 

[Karthik Thandapani]

Hi Jeffreyweir, Sure, I will have a look at those examples.

My requirement is to allow users to multi-select weeks or a month as a whole by showing a userform dropdown or a calendar. As per the selection the data is filtered and so the charts get refreshed.

Please see below links;

http://forum.chandoo.org/threads/userform-dropdown-for-a-calendar-view.18521/

http://forum.chandoo.org/threads/us...with-next-button-to-skip-to-next-range.18523/

To be crisp, a calender view with option buttons aligned left.

Please feel free to ask if you have any questions.

 

[jeffreyweir]

And how will the data be laid out that is getting filtered? None of your posts give us enough to go on, I'm afraid. It would be helpful to show the raw data, and what you expect the raw data to look like after the user has selected a date range.

You mention slicers in this post, but there are no pivottables in either of the download files at the other posts. Also, you have essentially posted the same thing in three different places on this forum. This makes it pretty time consuming for volunteers to help you out.