CODEWITHSUNDEEP
excelvbamacos
Eric Shreve
Eric Shreve

Reputation: 139

Trigger Macro with Slicer Change

I'm trying to modify data in a cell range when changing the selection in a slicer. Can this be done in Excel for Mac?

Upvotes: 0

Views: 6928

Answers (1)

Holger
Holger

Reputation: 330

Yes, it is! As @BigBen had already mentioned, it is possible via the event Worksheet_PivotTableUpdate. This is also supported by Excel for Mac.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
    
End Sub

It is important that the code is defined in the corresponding sheet module

Upvotes: 2

Related Questions