Friends,

How are you all?

I've created a quiz game (questions and answers for my pupils) in Excel and now there's only one little detail that I just don't know how to do. I need a COUNTDOWN! I've seen it once, but I didn't see the codes.

When I ask something to a player, this person has 10 seconds to answer the question. If he answers during the countdown, I stop the counter. If not, the counter hits "zero" and the text "Time up!" appears. That's it! Simple!

So, here's what I need...

1) A button to start the counter;
2) A code which refreshes a cell (A1, for example) every 1 second, from 10 to "zero" (a loop with A1 - 1, I guess);
3) The text "Time up!" (in A1) after hitting "zero";
4) A button to stop the counter anytime I want to, during the countdown.

My sheet and cell are ready. The buttons (StartCounter and StopCounter) are already created too. Now, I just need the code.

Note 1:
The button StartCounter lies in the main sheet. When I press this button, it takes me to another sheet (named counter) and starts the countdown. In the counter sheet lies the button StopCounter. When I press this button, it stops the counter and takes me back to the main sheet. If you want to show me two codes, one for each button, that's OK (I prefer so). If you show me one single code for both buttons, that's OK too. It's up to you.

Note 2:
I've searched for a countdown template on the internet, but all I got was "date and time templates". I don't need a countdown timer like that, for I won't use specific "date or time". I just need a code to subtract 1 from any number I decide, with a 1 second delay. It's a timer, offcourse, but it's nothing formated to "time". It's just a kind of loop like "CellX = CellX - 1" with a 1 second delay. Right? Now, if you prefer to use any procedure related to time events, that's OK for me. No problem.

Thank you very much for your attention, guys.

Hugs for all.

Bruno