LinkBack URL
About LinkBacks
hi guys what is the best way to make multiple countdown timers on one worksheet? i.e i want one counter counting down to zero. when it reaches zero i want another counter to automatically start counting down? is this possible?
hi guys what is the best way to make multiple countdown timers on one worksheet? i.e i want one counter counting down to zero. when it reaches zero i want another counter to automatically start counting down? is this possible?
Last edited by Dave_ross; 12-01-2011 at 05:17 AM.
Hi Dave_ross
Try......
add this to make sure thetimer is stopped before close
Please Login or Register to view this content.
Please Login or Register to view this content.
thats great. i should be able to adapt the cell numbers to the cell i need. Ill let you know if i manage. my excel skills are limited he he
once you get your head around the code it can be shortened toPlease Login or Register to view this content.
Last edited by pike; 11-29-2011 at 05:28 AM. Reason: Dim iTimer as date
ill see what i can do. i have attached what im working on to show you what im up too. thanks for your help
you could
format cells custom
00":"00":"00
then you are dealing with numbers not times
with
cells B2 C2 D2 formated as custom Format pattern
00":"00":"00
Please Login or Register to view this content.
this version is not counting down in time format? i.e 00:01:59. this one is doing 00:00:99?
Hi Dave_ross
Try this code in you workbook
but dont forget to putPlease Login or Register to view this content.in "Thisworkbook" ModulePlease Login or Register to view this content.
Perfect thanks
Thats great works a dream.
really gonna pick your brains now though...
What if i wanted to have these count down timers running but also have others running in other rows? do i create a new module with the correct cell numbers? I tried this and its telling me i have ambiguous names?
i want each row of counters to work independently if i can?
ill attach a copy to show you
Try changing the names in the new module by adding a One Or Two to the end of wall the variables sub etc... Module two will all have two at end
Hi Dave_ross
it will get very long
probably better to use one timer that controls all the off events
Please Login or Register to view this content.
Pike you are just the best!!Thanks alot for your help
hi i have been using the above code for a couple of months now but i notice that if it is left for an hour or so the timers stop & dont always reach zero?
what can i do to stop the timers stopping prematurely? because if they do it knocks everything off
Re: Best way to make multiple countdown timers
guys i have seen you multiple countdown timer i need to be able to create multiple count downs in various cell please advise how i have put in a file and i would like to be able to add in p5 p6 p7 and so on
please help !!!!!
ronald coletto
Ronald,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
sorry i am new to postings i will create a new one
sorry guys
I want multiple timers running independently of each other in column M, Starting with M2.
Dawn, welcome to the forum
Did you perhaps not notice post #17?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks