View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_5_] Otto Moehrbach[_5_] is offline
external usenet poster
 
Posts: 27
Default Stop a VB program from running

Soterro
On your keyboard, hold down Ctrl and hit Break. Break is near the upper
right corner of your keyboard. Doing this will stop all code. HTH Otto
"Soterro" wrote in message
m...
Hello,

If my VB program runs by mistake in an infinite loop, there seems to
be no way to stop it without killing Excel with the TaskManager.
I think there should be a way to just stop whatever the interpreter is
doing. The 'play/stop' toolbar of the VBEditor does not react in any
way when the program is running. Might be important also that the
program is sporting MsgBox'es so it is always waiting for an answer,
and I can't click from the dialog to the stop button in enough time. I
need to stop it _while_ it is waiting for an answer from me.
I'm running Excel 2000 on Windows 2000.

Any ideas appreciated,
S