Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
halt macro execution, inspect progress and then resume execution
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="joeu2004, post: 7364629"] You can sprinkle Stop statements at key junctures in your macros. Alternatively, you can set breakpoints by pressing F9 with the cursor hovering over a statement. You can also use F8 step through the code and ctrl+F8 to run to the statement where the cursor is hovering. If your macros loops, you can pause execution randomly by pressing ctrl+alt+Pause (on my computer). Alternatively, you might at logic to execute the Stop statement when a certain condition is met, for example when an iteration counter is a specific value. Press F5 when you are ready to resume execution. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
halt macro execution, inspect progress and then resume execution
Top