Using Events with the QueryTable Object
Before you can use events with the QueryTable object, you must first create a class module and declare a QueryTable object with events. For example, assume that you have created a class module and named it
ClsModQT. This module contains the following code:
After you have declared the new object by using events, it appears in the Object drop-down list box in the class module.
Before the procedures will run, however, you must connect the declared object in the class module to the specified QueryTable object. You can do this by entering the following code in the class module:
After you run this initialization procedure, the object you declared in the class module points to the specified QueryTable object. You can initialize the event in a module by calling the event. In this example, the first query table on the active worksheet is connected to the
You can write other event procedures in the object's class. When you click the new object in the Object box, the valid events for that object are displayed in the Procedure drop-down list box.