Export (0) Print
Expand All

QueryTable Object Events

Office 2007

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.

Bb211389.vs_note(en-us,office.12).gif  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.



Community Additions

ADD
Show:
© 2014 Microsoft