Stopping Excel Macro executution when pressing Esc won t work

Question

I m running excel 2007 on XP   Is there a way to stop a macro from running during its execution other than pressing escape   Usually if I think I created an infinate loop or otherwise messed something up I hit escape and it throws an error but the macro stops   This time  and I ve done it before but not this badly   I set up a msgbox for some quick debugging   Turns out it had to loop about 6000 times  which made means I had to  OK  6000 message boxes  which took several minutes   I didn t save before running  another mistake  so I couldn t open task manager to exit   Is there another way to stop the execution of a macro in case I goof up like this again

User · Answer

I also like to use MsgBox for debugging  and I ve run into this same issue more than once   Now I always add a Cancel button to the popup  and exit the macro if Cancel is pressed   Example code       If MsgBox  Debug message   vbOKCancel   Debugging     vbCancel Then Exit Sub

User · Answer

I ve found that sometimes whem I open a second Excel window and run a macro on that second window  the execution of the first one stops  I don t know why it doesn t work all the time  but you may try

User · Answer

CTRL   SCR LK  Scroll Lock  worked for me

User · Answer

ESC and CTRL-BREAK did not work for me just now  But CTRL-ESC worked   No idea why  but I thought I would throw it out there in case it helps someone else   I had forgotten i   i   1 in my loop

User · Answer

You can stop a macro by pressing ctrl   break but if you don t have the break key you could use this autohotkey  open source  code       ESC   SendInput     CtrlBreak    return   Pressing shift   Escape will be like pressing ctrl   break and thus will stop your macro   All the glory to this page

User · Answer

Just Keep pressing ESC key  It will stop the VBA  This methods works when you get infinite MsgBox s

User · Answer

Use CRTL BREAK to suspend execution at any point  You will be put into break mode and can press F5 to continue the execution or F8 to execute the code step-by-step in the visual debugger   Of course this only works when there is no message box open  so if your VBA code constantly opens message boxes for some reason it will become a little tricky to press the keys at the right moment   You can even edit most of the code while it is running   Use Debug Print to print out messages to the Immediate Window in the VBA editor  that s way more convenient than MsgBox   Use breakpoints or the Stop keyword to automatically halt execution in interesting areas    You can use Debug Assert to halt execution conditionally

User · Answer

My laptop did not have Break nor Scr Lock  so I somehow managed to make it work by pressing Ctrl   Function   Right Shift  to activate  pause

User · Answer

You can also try pressing the  FN  or function key with the button  Break  or with the button  sys rq  - system request as this - must be pressed together and this stops any running macro

User · Answer

I forgot to comment out a line with a MsgBox before executing my macro  Meaning I d have to click OK over a hundred thousand times  The ESC key was just escaping the message box but not stopping the execution of the macro  Holding the ESC key continuously for a few seconds helped me stop the execution of the code

User · Answer

Sometimes  the right set of keys  Pause  Break or ScrLk  are not available on the keyboard  mostly happens with laptop users  and pressing Esc 2  3 or multiple times doesn t halt the macro too   I got stuck too and eventually found the solution in accessibility feature of Windows after which I tried all the researched options and 3 of them worked for me in 3 different scenarios   Step  01  If your keyboard does not have a specific key  please do not worry and open the  OnScreen Keyboard  from Windows Utilities by pressing Win   U   Step  02  Now  try any of the below option and of them will definitely work depending on your system architecture i e  OS and Office version   Ctrl   Pause Ctrl   ScrLk Esc   Esc  Press twice consecutively    You will be put into break mode using the above key combinations as the macro suspends execution immediately finishing the current task  For eg  if it is pulling the data from web then it will halt immediately before execting any next command but after pulling the data  following which one can press F5 or F8 to continue the debugging

[vba] Stopping Excel Macro executution when pressing Esc won't work

Examples related to vba

Examples related to excel

Examples related to terminate