Excel Reference

QueryTable object events

Direct Answer

QueryTable object events
 is part of the Excel VBA object model. This reference page documents its syntax, parameters, and typical usage.

Reference

QueryTable object events occur when a QueryTable object is refreshed. These events are enabled by default. To view the event procedures available for a particular sheet, right-click the sheet tab, and then click View Code on the shortcut menu. In the Procedure drop-down list box in the Code window, click the name of the event you want to use.

  • AfterRefresh
  • BeforeRefresh

> NOTE:
> To write event procedures for a QueryTable object, you must first create a new object by using the WithEvents keyword in a class module. For more information, see Using events with the QueryTable object.

See also

!include[Support and feedback]

Reference: Excel object-model documentation • updated 11/13/2018
. Rebuilt for readability; see the original for complete parameter matrices.