How to mark down the time when entering input to a cell?

[Guest]

Does anyone know on how mark down the time when entering input to a cell?
such as
if I input "YES" into cell A1, and in cell B1 will display the current time
as a text, which will never change until a new input enter in cell A1.
Does anyone have any suggestion?
Thank you
Eric

 

[Peo Sjoblom]

You would need a macro for that

http://www.mcgimpsey.com/excel/timestamp.html

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey