to pause an application.wait loop

[aprildu]

I have an application.wait that I want to pause/break but I couldn't find a good way to do it. It seems no actions (selecting cells, pressing buttons, etc.) are allowed when it's running. Pressing keyboard Esc seems to finish the rest of the counter (c) faster. But how to stop the pause the loop at will (I don't want a counter)? Many thanks!

Please Login or Register  to view this content.

[6StringJazzer]

Try putting this inside your For loop:

Please Login or Register  to view this content.

That will allow you to break out of the macro but I don't believe you can do any user interface activity at all if a macro is running.

[aprildu]

Thank you Jeff. Is there a way to achieve what I want to do? I don't want a counter to predetermine how many times (or how long) the loop runs. I want to do something to stop scrolling at will. Maybe other ways such as ontime - an ontime routine within a loop?

[karedog]

Not sure what you are trying to achieved, but if you want a "window scroller", then try this :

Please Login or Register  to view this content.

The hotkey to be used is the ' key (the one exactly under escape key at top left of keyboard), as set by this statement :
Application.OnKey "`", "AutoScroll_Toggle"

To run the code, run the AutoScroll_Start sub, then you can pause/unpause anytime using the hotkey.
If you don't need the scroller anymore, run the AutoScroll_Stop sub (since the scroller takes CPU time, it is wise to stop it when no longer needed).

[aprildu]

Thanks Karedog. This is exactly what I was looking for! When I close the workbook, there is no need to run the stop sub so it won't take up resources? And when it's paused, it's not adding any overhead? I don't know much about how hot key related actions affect the performance yet.

[karedog]

You are welcome, thanks for the rep. points.
You can check the CPU and memory usage used by any program (Excel in this case), by opening and examining windows task manager. For modern CPU, this almost cost nothing, but it is still better a good practice to stop the macro once you don't need it anymore, because something unexpected could be happenned (could be anything) during the work of this "continous" macro, and this could lead to totally crash Excel, so it is wise to stop the macro once you don't need it any longer. And if you run another macro during the work of this scroller macro, you could experience a bad performance macro, since the vba by design is not multithreading, so a code has to wait another code to complete before it can run.