which event/method should be used to handle sheet refresh in VBA
 

While coding in excel macros using VBA, which event or method is triggered
when the sheet is refreshed.
Can anyone plz suggest.

which event/method should be used to handle sheet refresh in VBA
 

Your answer was visible to me before the question. That is service! <g

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
You need to define "refreshed".
--
HTH...

Jim Thomlinson


"Asha" wrote:

While coding in excel macros using VBA, which event or method is
triggered
when the sheet is refreshed.
Can anyone plz suggest.

which event/method should be used to handle sheet refresh in V
 

Asha

I assume that you have answered the question yourself. For future reference
try to be specific in your requests. A refresh could be a query, a pivot
table or any number of other things including feeds from external programs.
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

You need to define "refreshed".
--
HTH...

Jim Thomlinson


"Asha" wrote:

While coding in excel macros using VBA, which event or method is triggered
when the sheet is refreshed.
Can anyone plz suggest.

which event/method should be used to handle sheet refresh in V
 

Jim
Actually i have an excel sheet with a query, created through sql query
builder, whenever i refresh the query in "external data range" options, i
want to execute a particular VB code. To do so in VBA under which
method/event i have to define my code.
Hope this explains the scenario. Plz suggest
"Jim Thomlinson" wrote:

Asha

I assume that you have answered the question yourself. For future reference
try to be specific in your requests. A refresh could be a query, a pivot
table or any number of other things including feeds from external programs.
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

You need to define "refreshed".
--
HTH...

Jim Thomlinson


"Asha" wrote:

While coding in excel macros using VBA, which event or method is triggered
when the sheet is refreshed.
Can anyone plz suggest.