date last updated
 

Hello

Is there a way to show on the excel worksheet when it was last updated.
i.e. not when it was just last saved but when the data was actually modified
whether it be via a link or manually inputted. i know the time will change
every time any cell is selected but i need it to remember when a cell is
altered, ive tried using a circular reference but this only shows the time
that the data was origionally inputted i.e.
=IF(CF3="","",IF(CH3="",TODAY(),CH3))

any ideas

Regards

Hoyt

date last updated
 

I think that you would need VBA event code


Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit
Application.EnableEvents = False

If Target.Address < "$CH$3" Then
With Target
.Value = Format(Date,"dd mmm yyyy"
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"hoyt" wrote in message
...
Hello

Is there a way to show on the excel worksheet when it was last updated.
i.e. not when it was just last saved but when the data was actually
modified
whether it be via a link or manually inputted. i know the time will change
every time any cell is selected but i need it to remember when a cell is
altered, ive tried using a circular reference but this only shows the time
that the data was origionally inputted i.e.
=IF(CF3="","",IF(CH3="",TODAY(),CH3))

any ideas

Regards

Hoyt