View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_3_] Patrick Molloy[_3_] is offline
external usenet poster
 
Posts: 27
Default Clock Timer/ Date Function

We use the timer controls from this site:

http://www.mvps.org/ccrp/

If you have a text box on a userfor, then you'd place the
time in the box like this:-
textbox1.Text = Format(Now,"HH:MM:SS")

You orgram the Timer controls ONTIME event to run the
same line of code ... or similar

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I'm no programmer but is there a VB code that can

display
the existing time and date and a future time and date
(that you set) where it would show a countdown feature
for purposes of monitoring suspenses and deadlines in MS
Excel?

Thanks.

- Rob
.