Hello,
to add some text and the the current date to any existing comment in the sheet, for example, use code along the lines of
![]()
Dim cmt As Comment Dim mystr As String For Each cmt In Worksheets("Sheet1").Comments mystr = cmt.Text cmt.Text mystr & " last changed: " & Date Next cmt
Bookmarks