2013 Slicer Events

[PerryBeatty]

I've got a workbook with 2 worksheets, "Search" and "Data". The "Search" worksheet has 4 slicers that filter the rows in the "Data" sheet. I also have a userform that activates when the workbook is opened that gives the user the ability to pre-filter records by year (see attached slicer.jpg). What VBA event can I use to capture when ANY of the slicers on the "Search" worksheet have been clicked???

Hope you can help, Perry

[mancubus]

hi.

see if this article helps:
http://www.jkp-ads.com/articles/slicers00.asp

and
http://www.jkp-ads.com/Articles/slicers03.asp?AllComments=True


ps: Jan Karel Pieterse is one of our members.

[Bob Phillips]

Perry,

I am not aware of any of the slicer events being exposed to VBA, but if you select from a slicer the pivot table will reflect that selection, so could you trap the PivotTableUpdate event?