VBA: Automatic date update when other cells change?

[ineedhelp37]

Hi,

I am trying to find out a way to automatically insert the date in column H, when anything in columns A:G is modified (when in the same row). For example if I modify E3, I want the current time to automatically put in H3. The sheet is called "Master List". I tried looking at some of the other VBA posts, but they did not seem to work for this. I am somewhat new to VBA and am trying to learn!

Thanks so much

 

[njimack]

Paste the below code into the VBA module for the sheet in question:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <= 7 Then Cells(Target.Row, 8) = Now
End Sub

 

[ineedhelp37]

Thank you for such a quick reply! It works great.