Trying to perform a change event when value is changed within a range to highlight the cell that changed, and insert date and user into C1 and D1.
I have been searching about it for a few hours now everything I have found only works when the cell is blank. If the cell has existing values it is highlighted as soon as I select the cell. Tracking changes on the review Tab does not work because it has tables. Can anyone please help? Code I have so far is:
I have been searching about it for a few hours now everything I have found only works when the cell is blank. If the cell has existing values it is highlighted as soon as I select the cell. Tracking changes on the review Tab does not work because it has tables. Can anyone please help? Code I have so far is:
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Not Intersect(Target, Range("B:B,C:C,D:D")) Is Nothing Then
If Target <> "" Then Target.Interior.ColorIndex = 36
End If
End Sub