Edytuj

Udostępnij za pośrednictwem


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
Object

The worksheet that contains the PivotTable.

TargetPivotTable
PivotTable

The PivotTable that contains the edited or recalculated cells.

TargetRange
Range

The range that contains all the edited or recalcuated cells.

Attributes

Applies to