Creating a Running clock in excel without any button to start or stop clock

[Ravi181229]

Hi,

Is it possible to create a running clock (MM DD YYYY and Date) with time and date in two different colums. I dont want to create any button. clock should start running once excel workbook is opened. Any Ideas.

 

[wideboydixon]

Alt+F11 to bring up the VBA editor. In the ThisWorkbook module, paste the following:

Private Sub Workbook_Open()

Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTimer"

End Sub

Insert a new module and paste this:

Public Sub UpdateTimer()

Sheet1.Cells(1, 1).Value = Format$(Now, "mm/dd/yyyy")
Sheet1.Cells(1, 2).Value = Format$(Now, "hh:nn:ss")

Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTimer"

End Sub

Change those red lines as suits.

WBD

 

[Ravi181229]

Thank you So Much!!!

 

[ashyn]

Hello Everyone, I needed this to learn.. How to put a running clock on Cell A1 & landed in this tread.

The solution that you provided works, unfortunately the clock does not auto start when i close & open the excel file.
Can someone help me out here.. I dont want a Button to start / stop the clock.

I want the clock to be running (Auto) all the time the excel file is open.