Programming a runnig clock

[CoenraadJ]

Can anyone tell me why the following clock is not being updated continuously?

Public Sub Userform_Initialize()

Call Clock

End Sub

Sub Clock()

Label1.Caption = Time()
Application.OnTime Now + TimeValue("00:00:01"), "Clock"

End Sub

Any help will be appreciated.

[cytop]

Probably because the procedure called by an OnTime statement must be in a standard code module.

[meabrams]

Here's I a version that I found on the internet and have been using for a while. Label1 and the Userform Caption both have working time clocks

[AliGW]

I'm fascinated: why would anyone need this in an Excel file???

[CoenraadJ]

Here's I a version that I found on the internet and have been using for a while. Label1 and the Userform Caption both have working time clocks

Thanks, used it and it works great! Although I don't understand it completely.

I'm still unclear why Application.OnTime must be run in a core module.