DocEvents_PivotTableAfterValueChangeEventHandler Delegate

A Delegate type used to add an event handler for the PivotTableAfterValueChange event. The PivotTableAfterValueChange 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 DocEvents_PivotTableAfterValueChangeEventHandler ( _
    TargetPivotTable As PivotTable, _
    TargetRange As Range _
)
'Usage
Dim instance As New DocEvents_PivotTableAfterValueChangeEventHandler(AddressOf HandlerMethod)

[ComVisibleAttribute(false)]
public delegate void DocEvents_PivotTableAfterValueChangeEventHandler(
    PivotTable TargetPivotTable,
    Range TargetRange
)

Parameters

• 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