Down load John Walkenbach's clock spreadsheet. It isn't on a userform, but
the code is viewable and represents the mechanics of updating the clock
(using ontime). You would just adapt it to your userform (uncheck analog
clock to see the digital clock)

http://j-walk.com/ss/excel/files/clockchart.htm

--
Regards,
Tom Ogilvy

"dok112" wrote in
message ...

Hello,

I need some assistance...I need to create a form that is continuously
showing the current time in the 4 main time zones in the US (pacific,
mountain, central, eastern). It needs to basically tick like a regular
clock....any ideas???


--
dok112
------------------------------------------------------------------------
dok112's Profile:
http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=386909