Form.PivotTableChange Property

Access Developer Reference

Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the PivotTableChange event occurs. Read/write.

Syntax

expression.PivotTableChange

expression   A variable that represents a Form object.

Remarks

Valid values for this property are "macroname" where macroname is the name of macro, "[Event Procedure]" which indicates the event procedure associated with the BeforeInsert event for the specified object, or "=functionname()" where functionname is the name of a user-defined function.

Example

The following example specifies that when the PivotTableChange event occurs on the first form of the current project, the associated event procedure should run.

Visual Basic for Applications
  Forms(0).PivotTableChange = "[Event Procedure]"

See Also