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

[Eric]

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]

Please, don't multipost

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


"Eric" <[email protected]> wrote in message
news:[email protected]...
> 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