how to stop this loop - vba

[lezawang]

Hi
I ran the code below forgetting to add x=x+1 and excel displayed the message box and no matter what I do, the msgbox wont go and everything got frozen. I had to go to task manager and end the process. Any better way to stop that without losing the code. Thank you

Sub mywhile()
Dim x As Integer
Do While x < 6
    MsgBox "hi"
Loop
End Sub

 

[Rick Rothstein]

Hi
I ran the code below forgetting to add x=x+1 and excel displayed the message box and no matter what I do, the msgbox wont go and everything got frozen. I had to go to task manager and end the process. Any better way to stop that without losing the code.

The short answer is no.

 

[My Aswer Is This]

What is your objective?

Why would you want a message box to keep popping up saying "Hi" over and over?

 

[Rick Rothstein]

Why would you want a message box to keep popping up saying "Hi" over and over?

He does not want that. You missed his opening statement...

"I ran the code below forgetting to add x=x+1"

 

[Michael M]

Ctrl + break

 

[Rick Rothstein]

Ctrl + break

I don't know if that works or not as my keyboard (along with many of the newer keyboards) no longer have a Break key on them.

 

[Michael M]

It does work, but, as you mentioned, I didn't consider the newer keyboards....my laptop doesn't have it !!!
But for those that don't have BREAK, you could use

Ctrl + Fn + F11

Hate to think what it would be on a Mac.

 

[Rick Rothstein]

It does work, but, as you mentioned, I didn't consider the newer keyboards....my laptop doesn't have it !!!
But for those that don't have BREAK, you could use

Ctrl + Fn + F11

Hate to think what it would be on a Mac.

I am not sure what you think that key combination was supposed to do, but on my laptop, it made me log into my computer again and I was right back at the "stalled" MessageBox.

 

[Michael M]

Sorry Rick but it works for me.....but I do have a pretty old Dell laptop !!