AppEvents_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 AppEvents_SheetPivotTableAfterValueChangeEventHandler ( _
    Sh As Object, _
    TargetPivotTable As PivotTable, _
    TargetRange As Range _
)
'Usage
Dim instance As New AppEvents_SheetPivotTableAfterValueChangeEventHandler(AddressOf HandlerMethod)
[ComVisibleAttribute(false)]
public delegate void AppEvents_SheetPivotTableAfterValueChangeEventHandler(
    Object Sh,
    PivotTable TargetPivotTable,
    Range TargetRange
)

Parameters

  • Sh
    Type: System.Object

    The worksheet that contains the PivotTable.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace