Modify a cell when another cell is modified

[Gaviota]

Hi, all of you.
I have a colum with DATE and another with COMENT.
¿Is it possible to change the DATE cell to TODAY when I leave, modifing, the COMENT cell?
Best regards.

 

[VoG]

Hi. Assuming that the comment column is B and you want the date in A try this. Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
    Application.EnableEvents = False
    Target.Offset(, -1).Value = Date
    Application.EnableEvents = True
End If
End Sub

 

[Gaviota]

Thanks a lot VoG for your fast answer. It works fine.
I changed coll 2 to 4 becauce COMENT is in D and DATE is in C.
¿Can you explain what is that? I mean, its looks as a macro but it isn't.
Thera are no an added MODULE.
Best regards

 

[VoG]

It is a special type of macro called an Event Procedure. See http://www.cpearson.com/excel/Events.aspx

 

[Gaviota]

Thanks again VoG.