Timer for sheet

[andre1986]

Does anyone know how to make a timer / countdown function that runs for 2 minutes and then switches from one sheet to another?

So:

Run timer
If time = 120 sec
Then go to sheet "start"

Thank you

[CK76]

You'd use Application.Ontime

Something like below...

Please Login or Register  to view this content.

See link for more detailed tutorial on Application.OnTime.
http://www.snb-vba.eu/VBA_Application.OnTime_en.html

[Arkadi]

Hi Andre,

I don't know how you want to trigger the code, but running start_timer will wait 2 minutes, then worksheet "Start" will activate.

Please Login or Register  to view this content.

[daboho]

Sir askadi how to do use doevents not application on time.. I ever see use doevents how to fix this code

Please Login or Register  to view this content.

[/QUOTE]

[Arkadi]

DoEvents just allows the code to delay to run other things (I don't find it helps a lot most of the time), however, the method you are looking for should be something like this... round, 2 gives seconds which is why I've made it stop at 120. I put >= in case it is 121 seconds for some reason... if we stop only if =120 then if we miss 120 exactly it will never stop:

Please Login or Register  to view this content.