Hi,

I put the below formula in the cell A1, i need to refresh it every one
second so that it might look like a clock, can anybody help?

=NOW()

Hi,

Alt+F11 to open vb editor, right click 'ThisWorkbook' and insert module and
paste the code below in. Run the sub StartClock to start it and always
rememeber to stop it when exiting the workbook by running StopClock

Dim Go As Boolean
Sub StartClock()
Go = True
MyClock
End Sub

Sub MyClock()
If Go Then
Worksheets("Sheet1").Cells(1, 1).Value = Format(Now, "dd/mm/yyyy hh:mm:ss")
Application.OnTime (Now + TimeSerial(0, 0, 1)), "MyClock"
End If
End Sub

Sub StopClock()
Go = False
End Sub

Mike


"Pietro" wrote:

Hi,

I put the below formula in the cell A1, i need to refresh it every one
second so that it might look like a clock, can anybody help?

=NOW()