Macro to Run when Slicer Selection is Changed (multiple slicers)

Hi All,

I was searching for a way to run macro whenever I select an item on a slicer or whenever the selection is changed. The closest I found was the thread below.

http://www.excelforum.com/excel-prog...s-changed.html

Since I'm new to this I don't know where to put the macro and how to apply it on multiple slicers. The first Slicer has a category and the other has the sub category. I need it to run every time selection is changed on either slicer.

This is the macro I want to run if it helps.

Please Login or Register  to view this content.

Hi,

Put your macro code in a Module level procedure and assign that macro to the slicer

Hi Richard,

Thanks for the quick response. However, what I meant was for the macro to run on selection change. I may have confused you with the macro name (Macro1_Click) since I obtain that code by recording the macro when an object is clicked. Currently, the macro runs when the button/object is clicked. I want to eliminate the button click and have it built in when Slicer selection is changed.

I hope I explained it clear.

Edit: I just realized that I did not proof read the question before I posted it. Original post edited.

Assuming you are controlling a pivot table on the same sheet, use the Worksheet's PivotTableUpdate event. Right-click the sheet tab, choose View Code and paste this in:

Please Login or Register  to view this content.

No, you've explained it clearly. Except that there seems a contradiction since you mention the macro running on selection change and then later when the slicer is changed. Maybe you mean the two are the same things but it's confusing since the term Selection Change has a quite specific meaning in VBA, i.e. it refers to a Sheet

As I understand it when you pick a new slicer value you want the macro to run. If so that's what the code I gave you will do.

Upload the workbook with the code I gave if you think it's not working. The code needs to go in a module level procedure which is assigned to the Slicer object.

Thanks Rory!

Exactly what I needed.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread