Is there a way to interrupt a VBA code run?

[User Name]

Hello

I'm writing a VBA program with multiple loops that tends to get hung up during the beta testing process. Is there a way to interrupt the code and jump to the vba window?

 

[MrKowz]

Press the Esc key on they keyboard. This will force-break your code.

 

[repairman615]

You can also try the Break key. On the laptop I use it is tied to the fn key so in my case:

fn + Break stops the macro and keeps my junk from melting.

 

[User Name]

OK... great... thank you so much...

The ESC key doesn't work most of the time - in greys out the screen but that's about it. I think I've tried every key on the board but I'll try fn and fn + break. Thank you so much. I hate losing work and have put up with this state of affairs for far too long.

 

[User Name]

Grrrr... the FN + Break key and/or FN + Break + ESC deys don't work all the time either. Bummer.

 

[Blade Hunter]

Whenever I am building an app I have a boolean variable in there call DebugFlag and at the begining of any intensive loops or crazy stuff I have a simple If DebugFlag then blah blah to limit the transactions it will perform. I use it throughout the code all over the place to really restrict what I am doing, also to print out SQL calls and various data points to the immediate window.

At the start of the code I simply have DebugFlag = True or False depending what I am doing

Just a suggestion .

 

[User Name]

Thanks... I've used something like this with various results. The problem is it's hard to come up with a good set of debug logic for the problem I'm working on. But I think you're right. If KillLoop = 100000000 then step out. Not a bad suggestion.

 

[gino59]

Depending on your keyboard, I guess - but CTRL+Break always seems to cut the code run for me. And I use it a lot!!!!

Cheers,
Gino

 

[Ruddles]

Adding a DoEvents statement to your loops also helps the system recognise the keyboard.

If you do that, a button whose click event just peforms an End should stop a loop cold.

 

[DaveyDux]

Depending on your keyboard, I guess - but CTRL+Break always seems to cut the code run for me. And I use it a lot!!!!

Cheers,
Gino

I have found that with Excel 2010, one has to now use "Ctrl+Shift+Break" - you may want to make a note of that Gino, to use when you upgrade to Excel 2010 or later... unless Microsoft remedies it.