I'm building up some code on the back of a worksheet change event. But I cannot see where I am going wrong:
If any of the cell values C4 through to C27 are changed to "Done" then I would like to apply a value to the respective row in column J:
e.g.
cell C4 = Done
Change J4 to Now()
I'm a little unsure how to do that second part?
However I can't even do a basic change event in the first place!! Can anyone help with both problems (firing the event change code, and then putting a basic value in another cell)?
Thank you in advance.
If any of the cell values C4 through to C27 are changed to "Done" then I would like to apply a value to the respective row in column J:
e.g.
cell C4 = Done
Change J4 to Now()
I'm a little unsure how to do that second part?
However I can't even do a basic change event in the first place!! Can anyone help with both problems (firing the event change code, and then putting a basic value in another cell)?
Thank you in advance.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C4:C27")) Is Nothing Then
If Target.Value = "Done" Then Debug.Print "Hello"
End If
End Sub