Take a look at the event macro that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

LaDdIe wrote:

Hello,

OK, what i want to achive is this;
=IF(A10,NOW())
But!
How do I stop the time re-calculating each time?

Any help welcome

--

Dave Peterson