View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default Stop a VB program from running


"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.


Make sure the msgbox has a cancel button and use that to
stop execution

Keith