Countdown Timer

[nat1967]

HI,

Can someone show me how to write the VBA needed for a countdown clock? Starting at 5 minutes and working backwards showing minutes and seconds. After the 5 minutes is up, I would want it to perform another action. I cant seem to get he "clock" to go backwards. Going forward is no problem but backwards is just eluding me. Please give helpful posts the Stars they deserve. It makes the post more visible for others

Nathan
Senior Test Lead

 

[FancyPrairie]

Why not just create a public variable that holds your counter (intialized at 5 minutes) and every minute (or whatever) subtract 1 from your counter and display the current value on your form or whatever.

 

[nat1967]

FancyPrairie,

What can I say! A simple solution. Perfect!! Thanks for you help. I see your answers in a lot of the threads. You are truely an asset to this forum.

Thank You!!!! Please give helpful posts the Stars they deserve. It makes the post more visible for others

Nathan
Senior Test Lead