I don't think I guessed well at what was happening with FSt1's code, so I put
together something that should be close to what he had going on and you can
grab the workbook it is in and look at it all from:
http://www.jlathamsite.com/uploads/ExcelClockForm.xls
Just save it to your system and run it. There's some explanatory text in it
to help you see it working and to get into the VB Editor to learn more.

Hope it helps a bit.


"Scott R" wrote:

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