-
1 Attachment(s)
2013 Slicer Events
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
-
-
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?