Forcing a break in VBA if stuck in a continuous loop

[JetEscamilla]

I think the title is self explanatory. I have a macro running which I was doing step by step using F8. The sand dial is on my cursor because the macro is just running away. How can I force it to stop. Idiot me did not save before running and I dont want to lose what I just wrote.

 

[stanleydgromjr]

JetEscamilla,

Try:
Press and hold down the "CTRL" key, and press the "Break" (Pause) key.


Have a great day,
Stan

 

[Norie]

Well you can stop code with CTRL+BREAK.

But it's probably a good idea to investigate why the code is 'running away'.

 

[rconverse]

I think Ctrl + break will stop VBA from running.

HTH
Roger

 

[JetEscamilla]

Thanks for the responses

ctrl+break is not working for me. The sand dial stays on my cursor and will not let me click anywhere on the VBA window. It may be that excel just bugged out on me and not stuck in a loop. Any other ideals.

 

[Jonmo1]

You won't like this idea....

go get lunch, and wait for it to stop...

Otherwise, CTRL + ALT + DEL - end process

 

[JetEscamilla]

Well I had to Ctrl+Alt+Del it. Auto recover picked it up from an hour ago. Not too much was lost. Still frustrating, but I guess it could have been worse. Thanks for the replies everyone.

 

[Hoozits]

What if you don't have a pause/break key on your computer?

 

[VoG]

You can keep tapping ESC but in my experience that often doesn't work.

 

[Hoozits]

That was my experience as well. I guess I need to be more careful in future. Thanks for the reply.