Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display userform at certain time Anthony Excel Worksheet Functions 2 October 29th 08 04:21 PM
Userform - Entering Time TEB2 Excel Programming 6 April 25th 05 07:49 PM
Entering military time into a userform WillRn Excel Programming 3 March 14th 05 03:25 PM
TextBox in UserForm with 24h time format Mika Excel Programming 1 February 1st 05 07:45 PM
Converting Time in a userform tiptop[_8_] Excel Programming 2 July 27th 04 07:58 AM


All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"