Countdown timer

Is it possible to have a timer which has a variable timed session. eg 10mins or 12mins or 20mins. and you click on a start button to start it counting down but while it is running you can enter data into the cells and as soon as the timed session has elapsed you are not allowed to enter anymore data. until the sheet has been saved and the timer has been re-started.

thx for any help in advance.

Hello Ukmxer,

This example uses 2 macros. ActivateTimer can be assigned to a button on the worksheet. Clicking the button will start the count down. In this case it is set for 10 seconds. The time can be set from hours, to minutes, or seconds. When the time has expired a Message Box Dialog appears notifying you that time is up. Once the user responds, the SaveAs Dialog is displayed. The only way to get back to Excel is to save the workbook. Place this code in a Standard VBA module.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi Leith, thank you for your help. The macro works great.

Is it possible to have the timer displayed in a font of about size 48 whilst it is running, so the person doing the data input can see how much time is left before input is frozen.

thank you

Hello Ukmxer,

Not with this macro. Once it is activated, there is no way to access the time ticks. The only way I know of to do this is using an API timer. However, the API timer can become unstable and crash Excel. I have tried many techniques to improve its reliability, but I haven't been 100% successful.

Sincerely,
Leith Ross