Private Sub Worksheet_AfterRefresh()
Hello Everyone,
I need a macro sitting behind a worksheet that will trigger after an SQL Query refresh. The title of this post is my wish. Since I cannot find this option in the drop down boxes in VBA editor, I am wondering if anyone knows a workaround for getting this done.
sdruley
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
The worksheet_change event usually works since REFRESHES change the data on the worksheet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If you are talking about a Querytable, they do have both Before_ and After_Refresh events - you just need a WithEvents variable to trap it.
Remember what the dormouse said
Feed your head
Can you give me a small example of the WithEvents variable?
Steve
Sure - see Richard's code here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks