Quit macro

[VegasNath]

How can I quit a macro that has gone into an endless loop. I am getting an input box, followed by the creation of an email which is going to cycle 65 thousand times over. I cannot get into the vbe?

[HansV]

Try pressing Ctrl+Break (Ctrl+Pause).

[VegasNath]

No joy. pause and break are separate on my keyboard, combinations of each do not quit.

[HansV]

And Esc?

[VegasNath]

And Esc?

Esc quits the inputbox which triggers the email creation along with the next inputbox. I've really messed up here!

[HansV]

You can use Task Manager to kill Excel...

[HansV]

For the future: it is useful to insert a statement

DoEvents

within a loop, at least during testing. This will allow the operating system to process events such as the user pressing Ctrl+Break.

[VegasNath]

Thanks Hans, another lesson well learned!