running clock

[Ted]

I am using =now() function in cell A1 and frequently press F9 to update to
current time. Is there any way to continuously show the current time running
in the cell A1.

 

[Gary''s Student]

=NOW() will update whenever the spreadsheet is calculated. You can insert an
OnTime macro to automatically re-calculate every couple of seconds.

 

[Ted]

Thank you for your answer. I never created a macro before. Can you show me
how. Greatly appreciated.

 

[Gord Dibben]

Would you be happy with an addin with a timer?

See Bob Phillips' site

http://xldynamic.com/source/xld.XtraTime.html


Gord Dibben MS Excel MVP

 

[Gord]

If you read through this posting you will find a couple of
suggestions.

For the OnTime method see Chip Pearson's site for code.

http://www.cpearson.com/excel/OnTime.aspx

Or just use Bob Phillips' timer addin...............posted below.


Gord Dibben Microsoft Excel MVP