How to interrupt a VBA macro stuck in an InputBox loop?

[JenniferMurphy]

I can't post the exact code because its stuck in an InputBox loop. This is close to what it is. I mistakenly put the IsNumeric right after the InputBox, which catches both Cancel so there is no way to exit. How can I interrupt it? Thanks

Do
  vReply = InputBox(Time & " " & LastAction & vbCrLf & vbCrLf & Prompt, MyName, , 11000, 7000)
  'Cancel returns "", but so does "", so confirm both
  If Not IsNumric(vReply) Then GoTo BadInput

  . . .
 
BadInput:
  MsgBox "Invalid data", vbOKOnly, MyName
Continue:
Loop

 

[Z51]

On your keyboard, press CTRL+BREAK. You should then be able to End the code execution.

 

[JenniferMurphy]

On your keyboard, press CTRL+BREAK. You should then be able to End the code execution.

I tried that. At least, I think I did. I have a stupid SurfaceBook. It does not have a Break key, but I think Windows+r is break. It doesn't interrupt the macro.

It's stuck in that tight InputBox loop. If I press Win+r while the InputBox prompt is open, nothing happens. If I enter anything else, it puts the prompt back up too quickly for me to do anything.

 

[johnnyL]

Try the 'ESC' key multiple times.

 

[JenniferMurphy]

Try the 'ESC' key multiple times.

It treats Esc just like Cancel. It just puts the InputBox back up. I tried hitting Esc as fast as I could.

Win+r pops up the Run dialog. Is therwe a command I can enter there?

 

[johnnyL]

There are many you could try:

Ctrl+FN+B
Ctrl+FN+C
Windows+Esc

Can I ask why you can't just quit the script & redo the code?

 

[JenniferMurphy]

There are many you could try:

Ctrl+FN+B
Ctrl+FN+C

Those do nothing

Windows+Esc

That is treated the same as Cancel or Enter. It puts up the Invalid Data msg.

Can I ask why you can't just quit the script & redo the code?

How do I do that?

PS: I have the VBA editor open. Does that make a difference?

 

[johnnyL]

1) CTRL+ALT+DEL ... close Excel
2) Sledgehammer approach ... Remove Power cord and battery, Reinsert battery & power cord ... wait for device to reload

 

[JenniferMurphy]

1) CTRL+ALT+DEL ... close Excel

That would close Excel, but I am afraid I'll lose the last edits I made to the macro since saving it.

2) Sledgehammer approach ... Remove Power cord and battery, Reinsert battery & power cord ... wait for device to reload

I don't have to go to all that trouble. I can click Windows logo | Power | Power off or Restart. But I was hoping to be able to save the macro code changes. If I have to, I have to. But I'd like to find another way...

 

[johnnyL]

Well you can lose the last edits or stay stuck in an infinate loop where you can't do anything.