QueryTable

EventDescription3651916131007
AfterRefreshOccurs when ??YYYYYY
BeforeRefreshOccurs when ??YYYYYY

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

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