keep track of changes in the cells as comments in the affected cell.

Hi There , I have this VBS which I found online which keep track of changes in the cells as comments in the affected cell.


Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

Dim x As Variant, y As Variant

If Target.Count > 1 Then Exit Sub

Application.EnableEvents = False

x = Target.Value

Application.Undo

y = Target.Value

Target.Value = x

Application.EnableEvents = True

Target.NoteText Text:=Target.NoteText & Chr(10) & "Old value " & y _

& " changed to " & x & " on " & Format(Date, "mm-dd-yyyy") _

& " by " & Environ("username")

Target.Comment.Shape.AutoShapeType = msoShapeRoundedRectangle

Target.Comment.Shape.TextFrame.AutoSize = True

End Sub




But I will need to use it only for column T (Date value) to register changes in dates of these columns/Cells, great if someone can help

To get an answer to your thread, you must, first, comply with rule #3 about putting lines of code under CODE TAG.
Select your code above and click on CTRL+X to cut them out. Then click on the # icon above this text window and click on
CTRL+V to copy it again within the code tags.

Here is rule #3 :
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

and here is what it will look like when published.

Please Login or Register  to view this content.

And you have your anwser in the above code.
Hope this helps