Countdown problem

  • 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.

    Code below:


    Private Sub CommandButton1_Click()
    Range("N2").Value = Now
    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:

    Macro 1:

    ActiveCell.FormulaR1C1 = "12:01:00 AM"

    Macro 2:

    Application.Run "timer.xltm!sheet_calc"

    Very messy I know, is there a better way?


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!