Hi,

I'm trying to work out how to code a field so that if a cell (in a record row) is changed then in that row the value for "Date Last Modified" is updated with the current date.

Using the Worksheet_Change event handler I can do all this easily enough (see code below). However this won't work for cells that are updated by formulas. Has anyone got any ideas of how I can capture those cells that change when they are recalculated.

Thanks for any suggestions,

Tris

Private Sub Worksheet_Change(ByVal Target As Range)
Dim ChRow As Integer

If Target.Column = 17 Then Exit Sub ' Stops macro recurring when date is updated

ChRow = Target.Row
Cells(ChRow, 17) = Date 'Column 17 is the Date Last Modified Column

End Sub