ExcelBanter - View Single Post

plinius

Il 12/09/2012 17:50, ha scritto:
On Tuesday, September 11, 2012 3:36:34 PM UTC-4, (unknown) wrote:
Are there other functions beside NOW() that I can use to have the correct time displayed in a cell ?

For some reason it does not update all the time - there are pauses in the updates. So I'm looking for a time function that reflects the current time (hh:mm:ss) continuosly over the course of the day.

Put this in the "ThisWorkbook":

Private Sub Workbook_Open()
StartUpdate
End Sub

Then create a Module and put the

Sub StartUpdate()
Application.OnTime Now + TimeValue("00:00:01"), "StartUpdate"
Calculate
End Sub

Hi,
E.