For the moment my code add date to B2 anytime the Value in A2 changes.
The code looks like this:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim VRange As Range, cell As Range
Dim Msg As String
Dim ValidateCode As Variant
Set VRange = Range("A2:A10")
For Each cell In Target
If Union(cell, VRange).Address = VRange.Address Then
cell.Offset(, 2) = Date & " " & Time
End If
Next cell
End Sub
Here is what I need to add to the code:
Anytime the value in A2 changes - Current date is added to the cell, but to the next empty cell in the same row, so at the end I will have all dates when the value was changed.
Thank you in advance!
The code looks like this:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim VRange As Range, cell As Range
Dim Msg As String
Dim ValidateCode As Variant
Set VRange = Range("A2:A10")
For Each cell In Target
If Union(cell, VRange).Address = VRange.Address Then
cell.Offset(, 2) = Date & " " & Time
End If
Next cell
End Sub
Here is what I need to add to the code:
Anytime the value in A2 changes - Current date is added to the cell, but to the next empty cell in the same row, so at the end I will have all dates when the value was changed.
Thank you in advance!