編輯

共用方式為


AppEvents_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 AppEvents_SheetPivotTableAfterValueChangeEventHandler(System::Object ^ Sh, PivotTable ^ TargetPivotTable, Range ^ TargetRange);
[System.Runtime.InteropServices.ComVisible(false)]
public delegate void AppEvents_SheetPivotTableAfterValueChangeEventHandler(object Sh, PivotTable TargetPivotTable, Range TargetRange);
Public Delegate Sub AppEvents_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 recalculated cells.

Attributes

Applies to