Share via

Form.ViewChange Event

  • Article
Access Developer Reference

Occurs whenever the specified PivotChart view or PivotTable view is redrawn.

Syntax

expression.ViewChange(Reason )

expression   A variable that represents a Form object.

Parameters

Name Required/Optional Data Type Description
Reason Required Long A PivotViewReasonEnum constant that indicates how the view was changed. Reason always returns –1 for PivotChart Views.

Example

The following example demonstrates the syntax for a subroutine that traps the ViewChange event.

Visual Basic for Applications 
  Private Sub Form_ViewChange(ByVal Reason As Long)
    If Reason = OWC.plViewReasonShowDetails Then
        MsgBox "You've opted to show details."
    End If
End Sub