QueryTable object events

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

• Excel functions (by category)

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.