Hi Guys,
Im trying to get a virtual clock in excel and found this prev answer from
11/17/2007 which apparently works but I unfortunately, dont know anything
about 'forms' and am a little confused as to how to do this.. is there
another way to explain this procedure?

any help would be great as i really would like this to work.. below is the
prev answer i found..

Answer

hi
create a small form in excel with a single text box. then put this code in
the form.
Private Sub CB1_Click()
Load UserForm1
UserForm1.Show 0
Call xlClock
End Sub
Private Sub ShowxlClock()
If UserForm1.Visible = True Then
UserForm1.tb1.Value = Format(Now, "hh:mm:ss AM/PM")
Application.OnTime Now + TimeSerial(0, 0, 1), "xlClock"
Else
Exit Sub
End If
End Sub
you can install it as an addin. i have it in my personal.xls
i run this from a custom icon on my custom toolbar.

regards
FSt1