Timestamp vba

[RPM7]

I've got a very basic understanding of VBA & I'm trying to create a spreadsheet with a timestamp along with the username when a cell within a range is modified.

I've have found loads of examples of vba with different variations that're pretty close, but I can't seem to make them work for me.
The closet I've found will add a username and timestamp when cells in a singular column are changed. It offsets the stamp from this target range.

I have information in ranges A2:L34 & A40:L82, & I was hoping to create a stamp in column O & P with the username and time modified respectively.

Does anyone know how to do this?

Any help at all would be greatly appreciated as I'm going in circles.

 

[kahnailee]

OK, try this.

Private Sub Worksheet_Change(ByVal Target As Range)
  Dim Changed As Range, c As Range
  
  Const myTarget As String = "A1:A10"

  Set Changed = Intersect(Target, Range(myTarget))
  If Not Changed Is Nothing Then
    Application.EnableEvents = False
    For Each c In Changed
      If Len(c.Value) Then
        Cells(c.Row, "G").Value = Now
      End If
    Next c
    Application.EnableEvents = True
  End If
End Sub

How do you define where you want the timestamp? For instance, I would prefer to have it in A4, not next to a certain changed cell.

 

[kahnailee]

Sorry, found it: http://www.mrexcel.com/forum/excel-questions/528770-timestamp-cell-based-change-range.html

 

[Sphinx_82]

Thank you so much...I was looking for this too