View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Emile van Mierlo Emile van Mierlo is offline
external usenet poster
 
Posts: 11
Default How does msgbox stop the OnTime event?

If I run test below and leave the userform on the screen, the timer
ticks away till it's finished.


However, the MsgBox does not appear until I dismiss the userform.


Exactly. The code stops, but the timer keeps running.
When using a MsgBox, the code stops _and_ the timer stops.

Now, how can we stop the timer, like MsgBox can.

Emile