WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler Delegate

A Delegate type used to add an event handler for the SheetPivotTableAfterValueChange event. The SheetPivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Delegate Sub WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler ( _
    Sh As Object, _
    TargetPivotTable As PivotTable, _
    TargetRange As Range _
)
'Usage
Dim instance As New WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler(AddressOf HandlerMethod)

[ComVisibleAttribute(false)]
public delegate void WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler(
    Object Sh,
    PivotTable TargetPivotTable,
    Range TargetRange
)

Parameters

• Sh
  Type: System.Object

  The worksheet that contains the PivotTable.

• TargetPivotTable
  Type: Microsoft.Office.Interop.Excel.PivotTable

  The PivotTable that contains the edited or recalculated cells.

• TargetRange
  Type: Microsoft.Office.Interop.Excel.Range

  The range that contains all the edited or recalcuated cells.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace