Inject date in cell with one of three cells changed

[daowen]

Hello all:

I have a workbook that has a main summary sheet and multiple score sheets. The score sheets are created using VB and the base scores are copied over to the summary sheet.

On the score sheets only a few fields are not protected. There are three fields that have input sections. The employee has the ability to select a "No Comment", "Comments to reviewer" or "What I can do to improve". The first is a check box and the other two are free form input fields.

I have it so that when they select "No comment" the date they did that is recorded. I would also like to have the date recorded when they input text into the other two spots.

Things to note:

1 - The score sheets are based on a hidden template
2 - Need the date to be static when it is entered

Thanks in advance,

Doug

[D_Rennie]

could you not use somethink like

If Cells(1, 1).Value <> "" Then Cells(1, 2).Value = Now

then clean the Cells(1, 2) after the job has been done ready for the next job.

[daowen]

I appreciate that.

Each score sheet needs it's own date for when comments are added so I do not think this would work well.

Doug