Posted by steve on December 12, 2001 5:30 AM
Hi, I have tried this bit of code to automatically put the date into a cell if the adjacent cell = Yes. This works fine when entering Yes into the cell but wont work if I change the cell to a drop down. Choies Yes" & "No". Can any one assist? Thanks in advance
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 3 Then
ThisRow = Target.Row
If Target.Value = "Yes" Then
Range("d" & ThisRow).Value = Now()
Range("e" & ThisRow).Value = ""