title: VBA Last Change Method
body: <p>I am looking for a function to print in a comment box, who was the users that changed the data from that cell. What I have for now is this:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
     If Range("A" &amp; Target.Row).Value = "" Then GoTo EndeSub
     If Not Intersect(Range("C:JA"), Target) Is Nothing Then
       On Error GoTo EndeSub
       Application.EnableEvents = False
       Range("B" &amp; Target.Row) = Now
     End If
  EndeSub:
     Application.EnableEvents = True
   End Sub
  </code></pre>
  
  <p>It "triggers" automatically when someone types something in a cell.
  And is printing only the last user name that changed the data, but I want to be some kind of a log, to print all the users. Do you think it is possible?</p>