Time Userform

[dok112]

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??

 

[Tom Ogilvy]

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