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,

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,