Hi,
I would like to ask how to create a multiple count down timer in one sheet? like count down timer per row? is it possible?
Thanks,
Hi,
I would like to ask how to create a multiple count down timer in one sheet? like count down timer per row? is it possible?
Thanks,
A timer normally initiates an action at the end of its count-down. There are plenty of code samples on the internet which you can access with one quick search.
The action a timer counts down to can include many tasks. For example, you might have one timer that updates every row in your workbook every 5 minutes, even if the update of each row requires connection to a different data source.
The need for a timer on each row is as difficult to imagine as the effect of such a monster is scary. Imagine 100 rows, each one updating every 5 minutes using different timers. When would you get to use your computer?
What you most probably have in mind isn't merely a timer but a repetitive timer, like one that restarts itself after it has triggered action, meaning the action it triggers includes a restart of itself, enabling such action as doing something every 5 minutes. Such timers don't naturally stop when Excel is closed. They might be programmed to wake up the computer even when it's shut down and perform their assigned duty. Managing timers must therefore be done precisely, and that is the harder to do the more of them you have.
However, to answer your question, there is no obvious limit to the number of timers you can have working on one worksheet. This sentence clarifies one important point. Timers aren't "on the worksheet". They are embedded in Excel or, by Excel, in Windows and its their action that affects one or many worksheets, workbooks and even applications.
did you complete this?