| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| which event/method should be used to handle sheet refresh in VBA | Excel Programming | |||
| how to handle 'sheetchange' event on 'add-in' | Excel Programming | |||
| Can VSTO handle a Picture click event in Excel? | Excel Programming | |||
| PivotTable After Refresh Event??? | Excel Programming | |||
Linear Mode
