View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default How does msgbox stop the OnTime event?

Do you mean pause the timer or stop it?

Either way, you can either kill it or kill it and reset it.

Take a look at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm
particularly: Stopping A Timer Process



Emile van Mierlo wrote:

I think you're making an unwarranted assumption that a UserForm is
"similar to a MsgBox", at least in WinXL. There's nothing inherently
special about MsgBox - it works just like the Wait method or the
InputBox method - it halts the macro until the user presses a button,
but doesn't change XL's operating mode.


Ok, lets change the question: Do you know _how_ to stop the timer?

Thanks.

Emile


--

Dave Peterson