Countdown Timer

[thadacto]

I have the following code for a countdown timer but I want to be able to put the start time in the code itself, or by referring to the start time in another cell.
I have tried putting the start time in Cell A1 which works great - the time counts down in E1 where E1 =A1. However when the timer hits zero, the reference in E1 changes to the time 00:00:00 and the reference to A1 is disappears.

Any help much appreciated.

Please Login or Register  to view this content.

[Logit]

.
If I correctly understand what you are saying ... you could place an IF statement after your MsgBox "Countdown complete."

Please Login or Register  to view this content.

Understand the above is pseudo code. It may need editing.

Oftentimes, it helps to have your workbook attached to your request. Makes it easier to assist.

[thadacto]

Thanks, logit. Your advice was helpful and I did solve the problem in the end. However, I just cannot find a countdown timer that continues to run while the user types in answers to questions.

Thanks, anyway

[Zer0Cool]

However, I just cannot find a countdown timer that continues to run while the user types in answers to questions.

That is correct based on how you approached the timer as you cannot change 2 cells at the same time manually. To do this you likely want to represent the timer within an object on the sheet like a shape or textbox. The object should be able to be updated while the object is ticking away.

Generally speaking its also asking for trouble to try and have code run and user input happening at the exact same time. Depending on how much time the counter is counting down from may change how you handle this. I mean are we counting down from something like 5 seconds, 5 minutes or 5 hours?

The smaller the period of time the trickier it will be to juggle between counter and user input. Longer periods might give you flexibility to do something like change the time every 30-60 seconds until you get to say the last 15 seconds and then do it second by second.

I guess it would also be prudent if we knew the purpose of the timer. Until now I assumed it was for the users sake, however if its for you to be able to record how long the entire questionnaire takes or how long each question takes to answer there may be other approaches that can work how you need

[Logit]

.
Here are three count down timers that continue to run while the user is entering data into the sheet. Although the time display 'stops' while the user
has a cell active, as soon as the ENTER key is pressed, the timer displays the correct time that has transpired . Perhaps something here
will be of use to you ...