Time Userform
 

Hello,

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

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=38690

Time Userform
 

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