vba script to add comments on cell change

[Kaps_mr2]

Hello,

I have written a macro that creates a new workbook. I would like the ability to track changes in this second workbook - put a comment with a timestamp. I am sure i saw a way of doing this. The new workbook is saved to the cloud. Can someone point me in the right direction ? thanks

kind regards
Kaps

 

[Candyman8019]

You could try something like this:

It will record the date of the change, the user who made the change and also copy a range so you can track what changes.

Private Sub worksheet_change(ByVal target As Range)
If Not Intersect(target, Sheet11.Range("A2:M1000")) Is Nothing Then
lastrow = Sheet12.Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row + 1

   Sheet12.Range("A" & lastrow).Value = Now
   Sheet12.Range("B" & lastrow).Value = Environ("UserName")
   Sheet12.Range("C" & lastrow & ":O" & lastrow).Value = Sheet11.Range("A" & target.Row & ":M" & target.Row).Value

End If
End Sub

...just change your sheets and ranges to match your needs.