QueryTable

EventDescription16131007
AfterRefreshOccurs when ??YYYY
BeforeRefreshOccurs when ??YYYY

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

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext