Clock Timer/ Date Function

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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
 
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
 
Rob,

I will send you a workbook that has a multi-day count down timer.

HTH,
Bernie
Excel MVP
 
Rob,

Are you still looking for a reply to this one?

If so, I have a timer that sounds like what you want, but I need to modify
it to provide countdown as well.

Let me know.
 
Back
Top