Export (0) Print
Expand All

Worksheet.PivotTableChangeSync Event (Excel)

Occurs after changes to a PivotTable.

Version Added: Excel 2010

expression .PivotTableChangeSync(Target )

expression A variable that represents a Worksheet object.

Parameters

Name

Required/Optional

Data Type

Description

Target

Required

PivotTable

The PivotTable that was changed.

Return Value

Nothing

The PivotTableChangeEvent occurs during most changes to a PivotTable, so that you can write code to respond to user actions, such as clearing, grouping, or refreshing items in the PivotTable.

The following code example displays a message box that shows the name of the PivotTable the user changed.

Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable) 
 
With Target 
 MsgBox "You performed an operation in the following PivotTable: " & .Name 
End With 
 
End Sub
Show:
© 2014 Microsoft