Query Event
Occurs whenever the specified PivotTable view query becomes necessary. The query may not occur immediately; it may be delayed until the new data is displayed.
Private Sub Form_Query()
Example
The following example demonstrates the syntax for a subroutine that traps the Query event.
Private Sub Form_Query()
MsgBox "A query has become necessary."
End Sub