Countdown timer
I am trying to insert a timer into a column cell range that will countdown in hours, mins, and sec, when I enter the time. example: when I enter the "time in hr,mins,sec" it will start to countdown to Zero automatically, when I hit the enter key.
Any Ideas!
Thank you.
Last edited by Trickypottermus; 11-13-2013 at 02:02 PM. Reason: Jim885 worked Brilliant on single cell, just need it to work on a range of cells!
Put 20:00:00 in cell A1.
Then put these two subs in a module, then use Alt+F8 to trigger the Timer sub.
Please Login or Register to view this content.
Thank you Jim885
It worked in cell A1 Everything ok.
How would I get it to work in Multiple cells? say A1 through A25!
Thanks for your help!
Last edited by Trickypottermus; 11-13-2013 at 07:52 AM.
Thank you Jim885
It worked in cell A1,
Is it possible to have the timer start when I enter the time,
and can it be used in Multiple cells?
Last edited by Trickypottermus; 11-13-2013 at 08:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks