How can I Automatically refresh the NOW() Display in EXCEL?
 

I am using NOW() to display the Date and Time on an Input Form within EXCEL.
How can I most easily (and efficiently) refresh this form every minute, so
that the Time is Updated on this display?

Thanks,

How can I Automatically refresh the NOW() Display in EXCEL?
 

You could use the OnTime method.

Se Chip Pearson's site for info and code.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP

On Mon, 13 Nov 2006 13:50:01 -0800, CPodd
wrote:

I am using NOW() to display the Date and Time on an Input Form within EXCEL.
How can I most easily (and efficiently) refresh this form every minute, so
that the Time is Updated on this display?

Thanks,