How do I get the NOW() function to continuously update in the hours, minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed

On Jan 21, 1:14*pm, Ed wrote:
How do I get the NOW() function to continuously update in the hours, minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed

You might want to check this site out. It also has a downloadable
spreadsheet with the sample
http://www.dailydoseofexcel.com/arch...digital-clock/

Where? On a UserForm perhaps...

Give this a try. Right-click the UserForm's ToolBox and select "Additional
Controls" from the popup menu that appears. Scroll down to "Microsoft Status
Bar Control 6.0" and select it. This will add the "Status Bar" control to
the Toolbox. Place a "Status Bar" control on your UserForm. Highlight
(select) and click on the Custom property in the Properties window and click
on the button with the "three-dots" caption. You can play around with adding
panels and what not, but for your requested option, click on the Panels tab.
One panel should already exist on the "Status Bar" by default. Change that
panel's Alignment property to 2-sbrRight, Style property to 5-sbrTime and
AutoSize property to 1-sbrSprint. Hit OK and watch the displayed time change
automatically.

Rick


"Ed" wrote in message
...
How do I get the NOW() function to continuously update in the hours,
minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed

Hi Rick,

That works great. Can I get the seconds to update also?
--
Ed


"Rick Rothstein (MVP - VB)" wrote:

Where? On a UserForm perhaps...

Give this a try. Right-click the UserForm's ToolBox and select "Additional
Controls" from the popup menu that appears. Scroll down to "Microsoft Status
Bar Control 6.0" and select it. This will add the "Status Bar" control to
the Toolbox. Place a "Status Bar" control on your UserForm. Highlight
(select) and click on the Custom property in the Properties window and click
on the button with the "three-dots" caption. You can play around with adding
panels and what not, but for your requested option, click on the Panels tab.
One panel should already exist on the "Status Bar" by default. Change that
panel's Alignment property to 2-sbrRight, Style property to 5-sbrTime and
AutoSize property to 1-sbrSprint. Hit OK and watch the displayed time change
automatically.

Rick


"Ed" wrote in message
...
How do I get the NOW() function to continuously update in the hours,
minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed

Thanks. That is pretty neat.
--
Ed


"GTVT06" wrote:

On Jan 21, 1:14 pm, Ed wrote:
How do I get the NOW() function to continuously update in the hours, minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed

You might want to check this site out. It also has a downloadable
spreadsheet with the sample
http://www.dailydoseofexcel.com/arch...digital-clock/

Hi,

I am replying to your answer again because my first reply did not get posted.

Can you add seconds to the clock?
--
Ed


"Rick Rothstein (MVP - VB)" wrote:

Where? On a UserForm perhaps...

Give this a try. Right-click the UserForm's ToolBox and select "Additional
Controls" from the popup menu that appears. Scroll down to "Microsoft Status
Bar Control 6.0" and select it. This will add the "Status Bar" control to
the Toolbox. Place a "Status Bar" control on your UserForm. Highlight
(select) and click on the Custom property in the Properties window and click
on the button with the "three-dots" caption. You can play around with adding
panels and what not, but for your requested option, click on the Panels tab.
One panel should already exist on the "Status Bar" by default. Change that
panel's Alignment property to 2-sbrRight, Style property to 5-sbrTime and
AutoSize property to 1-sbrSprint. Hit OK and watch the displayed time change
automatically.

Rick


"Ed" wrote in message
...
How do I get the NOW() function to continuously update in the hours,
minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed