Countdown Timer in userform

[mangoskogen]

Hi

I'm working on kind of a sheet for registering statistics. What i have is the different sheets, and the userform i use to enter the stats. In my userform there's a bunch of buttons, that adds values to different cells when pushed.

What i need/want, is to be able to have some kind of countdown timer, counting down in minutes, seconds, and tenths(/hundreds) in the same userform. Mainly counting down from 10minutes. When i push the buttons for registering statistics, i want it to also register the time left, or time passed(not the time of day, so time/date/Now isn't good enough).

I'm certainly not a master of excel, or vba. I have been scouring google for something i can use, and have found lots of things that i can almost use, but that i can't get to work just the way I want

Is there anyone in here that is able to help?

 

[John_w]

To achieve a resolution of less than 1 second, you'll need to use a Windows timer - see http://www.cpearson.com/excel/OnTime.aspx.

Call GetTickCount to get the start 'tick' milliseconds and compute the future end 'tick' milliseconds based on your required 10 minutes countdown, and from this you can compute the elapsed time and time left every time the timer fires or when you want a timestamp.