How to automatically fill text if text in another cell is changed or added

[SunnyAlv]

I am a beginner when it comes to using VBA EXCEL, i hope u can help me

VBA Question

please see image below

I just want to know how to fill the day (TODAY) in each cell in column "A" if :

1. Columns C - F have been filled with text but have changed (in whatever form the essence has changed)

2. every time a new item is added to the last row


***adding the date (TODAY) according to the row the item was changed/new item added


Thank U

 

[kevin9999]

See if the following gives you what you want. As it is worksheet event code, you add it by right-clicking on the sheet tab, select View Code & place the code in the window that appears on the right of the screen. You'll need to save the file as macro-enabled or binary format thereafter.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row > 1 And Not Intersect(Range("C:F"), Target) Is Nothing Then
        Application.EnableEvents = False
        Cells(Target.Row, 1) = Date
        End If
    Application.EnableEvents = True
End Sub