VBA to Select Current Month Slicer

[Renee Beacham]

Hello,

I'm wondering what the VBA code would be to select the current month within a slicer.

I have reports which are updated monthly and I would like to automate the process of updating the month slicer to the current month.

An example slicer name is UpdatedMonth.

Thanks,
-Renee

 

[NARAYANK991]

Hi Renee ,

See if you find this helpful :

http://blog.softartisans.com/2013/02/18/how-to-select-slicer-values-with-vba/

In case you need further help , please upload your workbook with the data , pivot table and slicer in it.

Narayan