check this thread....
http://www.excelforum.com/showthread.php?t=364995

Mangesh



"Mark" wrote in message
...
Hi all,
I can enter the time in a cell by using the =now() and can update it by
hitting the F9 key but how can I make it change automatically to always
remain the same as the computer clock. I would imagine I need a macro to
do
it ...can someone please help me.

Thanks....Mark