Is there a way to make a countdown live? That is, can you make the cell tick down the seconds in real time? If cell A1 has days, A2 has hours, A3 has minutes and A4 has seconds....I'd like to be able to see the numbers actually moving in real time, is that possible?
How about this?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
It is only a few cells. One for days, another for hours (days cel * 24), another for minutes (hours cell * 60) and one more for seconds (minutes cell * 60)
Did you check the link?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I am not able to download that workbook. Any way someone could provide the code in text?
Tell us why you couldn't download it and we can help you. I belive it is quite a lot of code as I recall.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
This code is very hard to manipulate, especially since it ticks up and not down. I have the cells calculated off of each other (different cell for seconds, minutes, hours and days). But want each to count down accordingly: seconds count down every second and so on...Any suggestions?
That is a bit different from not being able to downlkoad, and whilst I disagree that the code is hard to manipulatre (it is extremely well-written <g>), here is a simpler version
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Sorry I guess I am a bit of a VBA novice. However, xld you make things very easy. Code worked flawlessly, thank you.
Interesting.. always confused on the timer
Posting Permissions
Reply With Quote
