Stopwatch Question in wrong group

[Navyguy]

I posted this in the Misc group verses the programming group.

Any help would be appreciated.

Cheers

http://www.excelforum.com/showthread.php?t=368352

[Leith Ross]

Hello Navyguy,

I looked over the stopwatch code and it's fine. The program uses a pair of command buttons that save the time the user presses the Start button and the time when the user presses the Stop button. The keyword Timer exists in VBA. It simply returns the number of seconds since midnight. You don't need to create a true VB timer which is a routine that generates a system interrupt. Your program is fine the way it is.

Sincerely,
Leith Ross

[Navyguy]

Thank-you for taking the time to have a look at the programme/coding. The only problem with the program is that is does not work.

If you start the countdown timer(top right), that works fine, but when that is running and you also start one or more of the stopwatches (leftside) the countdown timer stops and then needs to be reset.

Both the countdown timer and the stopwatch (or all the stopwatches) need to work independently from each other.

At first I thought it had to do with the DoEvents command, but after doing some research I am now thinking that an actual timer fuction is required.

Additional comments are appreciated.

Cheers

John

[Leith Ross]

Hello John,

If you do decide to use real timers, the system has a maximum limit on the number of timers you can use. Be sure to find out how many you system can support.

Sincerely,
Leith Ross

[Navyguy]

Thanks for the advice. Sorry for not responding sooner...good help is hard to find. I will try to research your point and see what I come up with and try to make some progress on this project.

Cheers

John

[Leith Ross]

Hello John,

Since VBA doesn't have a timer function like Visual Basic, timers can be created using the API (Applications Programming Interface). If you are interested I have the API macro code to create timers. They very easy use. Let me know.

Sincerely,
Leith Ross