Good morning,
I have a range (I:I) in which the data is validated to "Yes" or "No" selections.
If the user selects "Yes" in colum "I", I want the date to appear in the adjacent cell in column "J". If the user selects "No", I want column "J" to remain blank. I have managed to get this far however the date is not static, and updates each time the worksheet is opened.
Can anyone assist?
Here is my working so far:
I have a range (I:I) in which the data is validated to "Yes" or "No" selections.
If the user selects "Yes" in colum "I", I want the date to appear in the adjacent cell in column "J". If the user selects "No", I want column "J" to remain blank. I have managed to get this far however the date is not static, and updates each time the worksheet is opened.
Can anyone assist?
Here is my working so far:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If NotNow = True Then Exit Sub
'if activecell is in Column ? then...
'add date to adjecent column ?+1 cell
If Target.Column = 9 Then
NotNow = True
Target.Offset(0, 1) = Now()
NotNow = False
End If
End Sub