MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Refreshing the clock


Posted by Chris Whitehead on December 04, 2001 7:49 AM

I want to show the clock running in Excel. I can input current time using =now() but this doesn't update automatically. I have to press F9 each time. I am wanting to use the output from the clock in a formula to show costs increasing in line with the time.

Any ideas.

Chris


Posted by Kristy on December 04, 2001 8:55 AM

In Excel, go to Tools/Options/Calculation and see if it's set on Automatic or Manual. When it is set to manual, you have to press F9 to calculate.

Kristy

Posted by Juan Pablo G. on December 04, 2001 9:16 AM

I think that what you're looking for is this:

http://geocities.com/aaronblood/pages/vba.html

and check number 1.

Juan Pablo G.