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.