ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pause macro (https://www.excelbanter.com/excel-programming/371633-pause-macro.html)

Art Parra

pause macro
 
How do I include a "pause" and restart option on the following macro? I
have a while variable othervariable count records where certain
conditions are met and exit when othervariable is equal to variable. The
macro redraws some charts so it looks like a dynamic chart. I want to
pause the while and continue at any time.

thanks,



Tom Ogilvy

pause macro
 
Divide it into two macros
End the first macro. Provide some way to execute the remainder.

--
Regards,
Tom Ogilvy



"Art Parra" wrote in message
...
How do I include a "pause" and restart option on the following macro? I
have a while variable othervariable count records where certain
conditions are met and exit when othervariable is equal to variable. The
macro redraws some charts so it looks like a dynamic chart. I want to
pause the while and continue at any time.

thanks,






All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com