WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler Delegate

Definition

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).

public delegate void WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler(System::Object ^ Sh, PivotTable ^ TargetPivotTable, Range ^ TargetRange);
[System.Runtime.InteropServices.ComVisible(false)]
public delegate void WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler(object Sh, PivotTable TargetPivotTable, Range TargetRange);
Public Delegate Sub WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler(Sh As Object, TargetPivotTable As PivotTable, TargetRange As Range)
Parameters
Sh

The worksheet that contains the PivotTable.

TargetPivotTable

The PivotTable that contains the edited or recalculated cells.

TargetRange

The range that contains all the edited or recalcuated cells.

Inheritance
WorkbookEvents_SheetPivotTableAfterValueChangeEventHandlerWorkbookEvents_SheetPivotTableAfterValueChangeEventHandlerWorkbookEvents_SheetPivotTableAfterValueChangeEventHandler
Attributes

Applies to