How to exit from stuck VBA macro??

[benjiboo]

I don't seem to find a way to exit from my macros if I've programmed them wrongly and I'm stuck in a loop.

So far my only resource is to restart the PC. There's got to be a better way.

I am running excel and VBA on a PC, used to program on Macs where I could escape when I ran into programming glitches.


Thanks for any help!

benji

 

[bandit_1981]

Cntrl-Break should stop it and then you can cancel the program run

 

[shajueasow]

Also try the ESC (Escape) key.

 

[benjiboo]

Thanks for the suggestions.

[esc] and (Ctrl [esc] too) i'd already tried to no avail.

Which key is [break] exactly???

(I'm on a Frenc keyboerd btw)

 

[bandit_1981]

Mine is to the right of the scroll lock key.

[Print Screen] [Scroll Lock] [Pause/Break]

 

[benjiboo]

Now I've got it! It was a key named [arr déf], to the right of my function keys (laptop) and left of [pause] key.

Thanks for your time, much appreciated, wishing you a very good day and happy new year!

 

[bandit_1981]

No Prob have a great new years