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

[Guest]

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,

 

[Gord Dibben]

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