Auto insert date based on condition of another cell

i wanted to "auto insert the current date in cell A1 IF A2 has any data in it. i did that successfully as follows:

Please Login or Register  to view this content.

BUT,...... it changes every day or maybe its changing every time i load the workbook. i need it to insert at the time of data entery into A2 and then stay there from then on out. any ideas?? I only want NOW() to execute once.

Have a search in this forum for "time stamp". There are plenty of examples how to do this. It will require VBA, though.

As mentioned by Tevelyn, this concept is called TimeStamp and the code below should be helpful..

Please Login or Register  to view this content.

Try this and let me know as I am no good in VBA..