Excel VBA - Multiple procedures in 1 sheet to set up multiple timers
Not a programmer, came across a site that has a stopwatch timer.
Works great, i wanted to add multiple timers to about 6 rows, so i modified the procedure below. While at first it appears to work the problem is the next row that starts a timer will start where the row before it left off. How can i isolate each timer to be independent?
Please Login or Register to view this content.
.
Here is an example project that you can draw from. This is only a portion of the code :
Please Login or Register to view this content.
These three variables are declared at the top of your module, which means they are global and shared by all procedures:
To fix your problem you need to declare a separate set of StopIt, ResetIt, and LastTime for each timer, instead of all the timers sharing the same variables.Please Login or Register to view this content.
The code you grabbed is a somewhat unorthodox way of doing timers because each timer is in a continuous loop to determine if it's time to advance the timer to the next second. I did not test it but it seems like this would chew up a lot of CPU time. If it works for your purposes then I'll leave well enough alone.
makes sense, but when i add private and a new variable name for the next timer i get an error. appears you cannot add another declared variable after the first procedure? what would it take for you 6StringJazzer to write the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks