I have some coding that does a countdown, however, it does the first second then doesn't show the countdown from then on. It only counts down when I close down and open again....not that helpful!!!
Is there a way to keep the countdown running? (I know it is running in the background).
Here is some of the code I am using.
Sub sheet_calc() dt = 1 / 24 / 60 / 60 t = Range("d27").Value If t > -dt Then Application.OnTime Now + TimeValue("00:00:01"), "sheet_calc" If t < dt Then Application.Speech.Speak "Warning. warning. warning. warning. warning" ActiveSheet.Calculate End If End Sub
In cell Q1 I have this formula
Cell N1 has the date and time in this format: dd/mm/yyyy h:mm
And I have 2 macros that has this:
Very messy I know, is there a better way?