QueryTable

Event	Description	365	21	16	13	10	07
AfterRefresh	Occurs when ??	Y	Y	Y	Y	Y	Y
BeforeRefresh	Occurs when ??	Y	Y	Y	Y	Y	Y

Event Procedures

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