VBA code to update Excel date only if changes occur

[katkth7533]

Hi! I was hoping someone can help me with a vba code for Excel. I have a worksheet where I want the status date to update automatically to the current date but only when data is changed within certain cells; not when the file is opened or saved. In my example, the worksheet is called "Milestone". I want the date in cell "L2" to reflect the current date if ANY thing is changed in cells "B7:L35". And only on this sheet. I keep getting stuck. Any ideas? Thank you!

 

[ParamRay]

Place this macro in the code module for your "Milestone" worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim WorkRange As Range
    Dim DateRange As Range
    
    With Me
        Set WorkRange = .Range("B7:L35")
        Set DateRange = .Range("L2")
    End With
    
    If Not Intersect(Target, WorkRange) Is Nothing Then
        DateRange.Value = Date
    End If

End Sub

 

[tililing]

Hello can you help me with the code to use. I want my sheet not to auto update the date when no changes made. But it appears that the date always updated to the current date. Please me.

 

[tililing]

Every time I press the process button to sheet 2 and there is a msg appear the this plan already process want to continue. I selected NO. but the date in sheet 1 change into current date