Endless Loop

[MikeDBMan]

Frequently when I am entering code in VBA, I will execute the code. But if I inadvertently created an endless loop sometimes my screens will go tinted white and I cannot interrupt the code. How can I stop the code without having to lose all my latest work? If I remember, I will add a doevents line in my loop which will allow me to interrupt the loop but sometimes I forget that as well. Suggestions?

 

[Gavin T]

You can press Ctrl+Break.

You can also add max values in a loop for example if you know a loop shouldn't run more than 1,000 times you can add this:

Do
    i = i + 1
    If i > 1000 Then Exit Do
Loop

 

[vds1]

post your code. Maybe we can see why does your loop run forever and freeze.

 

[MikeDBMan]

If I had thought of something like the max value I would have put it in there. The problem is that it is too late and the code is running in an endless loop. Ctrl-Break does NOT interrupt it. Is there any way to interrupt it after I have gotten to this point? I have inadvertently been able to stop it before losing everything before but frankly I don't know what key combination I may have hit that did the trick. Surely someone else has this same experience out there?

 

[dlowrance]

Did you try Ctrl + Alt + Del?

Hit cancel once the screen comes up and try hitting Ctrl + C or ESC repeatedly.

 

[MikeDBMan]

I cannot seem to get this suggestion to work. (Ctrl+Alt+Del) then Cancel and Ctrl-C or ESC). I did it to myself again today and had to close down Excel and revert back to the last auto-saved file. Any other suggestions?

 

[VerlindenG]

For me, this worked already several times: CTRL-ALT-PAUSE + F12 to stop an endless loop, when the keyboard has no BREAK-button