Staic Date Stamp for adjacent cell being equal to "Dormant"

Hi, Ive searched this forum for hours trying to find an answer but couldnt find an exact answer.

I have a range of cells I4:I3116. When the word "Dormant" is selected from the dropdown in this range I would like a static date stamp entered into the same row of the range K4:K3116.

I have this code but cant manipulate it to work.. Thanks.

Please Login or Register  to view this content.

Brian

Thanks,

Where would that fit into the code?

Thaks ok Ive changed it but nothing happens.

Ive more than one Private sub within this worksheet and initially whenI ran this one it said "Compile Error" Ambiguous Name Detected. Worksheet_Change.

I changed it to Worksheet_Date but dont know if this is valid. Do you have any ideas.

Here is the other Private Sub within the sheet

Please Login or Register  to view this content.

Thanks for your help.

Sorry you will have to bear with me.. I have them in the sheet code..

Please Login or Register  to view this content.

When I change my dropdown to Dormant I get he compile error message. and it highlights this piece of the code I want to use to Date Stamp.

Please Login or Register  to view this content.

I hope that makes sense.