QueryTable

VBA

Before you can use the events you must add a class module and declare a QueryTable object with events

Public WithEvents myQueryTable As QueryTable 

Before the events will run they need to be connected to the corresponding query table object.
This can be done by adding the following code to the class module.

Sub InitQueryEvent(QT As Object) 
   Set myQueryTable = QT 
End Sub