Automatic date refresh on edit

[stevembe]

Is there a way I can put a date in a cell that will refresh to the current date if a sheet has had any editing done to it but it remains the same if the sheet has only been read?

 

[ZAX]

You should type the following code in the sheets' code.
You can replace "A1" with the cell address that has the date.

Private Sub Worksheet_Change(ByVal Target As Range)
Range("A1").Value = Date
End Sub

ZAX