hi can i run multiple timer in the same sheet ??? i try to change the sub whit a different name but only run the same cell event if i change in the marcro
?
thks
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
run mutiple timer in the same sheet
0
Answers
0
The answer to your question is both no and yes.
There is only one time in the world, and there is only one clock in your computer. This clock ticks away regardless of whether you look at it, let your programs look at it, or just let it tick.
Timer is a function that allows you to run programs at certain points of time. You can specify absolute times, like 12/31/2019 12:00PM, or relative times, like "10 seconds after I started a counter".
You can have many counters and many absolute points. You can run different programs at different times. If you want to run the same progam consider a loop which triggers a run every hour, on the hour, for example. When programming such loops make sure that the end is specified neatly.