VBA countdown timer

[ineedmoneh]

Hello,

I have made a countdown timer and used some VBA code to trigger it. Now i want to remove all formulas used and express everything with VBA, but i simply dont uderstand how to write it. Have tried:

Please Login or Register  to view this content.

but then the timer does not work.

Original file attached. I want to remove all formulas from it and leave only VBA.

Any guidance or help appreciated.

[davesexcel]

At the end of the code you need to call another macro, that calls the countdown macro again, you also need a way to stop the code.

I just thought of placing the word "Stop" in D1 and the loop will stop.

Please Login or Register  to view this content.

[ineedmoneh]

Hi davesexcel,

Thank you for this! It works almost perfect

The issue i am having with it now is that when multiple workbooks are opened and i try to close the countdown file, it reopens again.

I have simple on open and on save code that starts the countdown macro.

Please Login or Register  to view this content.

Any idea what causes this issue?

Thanks.

[torachan]

The attached is another approach, press key to continue, picks up the countdown automatically.
At present hard coded into your end time ( 01/01/2020 00:00:00 )
You could alter this by putting your terminal date/time in a cell and referencing the code to this.
torachan.

[bakerman2]

Try this way.

In Standard Module.

Please Login or Register  to view this content.

In ThisWorkbook.

Please Login or Register  to view this content.