Is there a function or formula for 19 used to record the date the contents of
another cell are modified? For example, if the entry in cell A1 is "beta"
and the entry of "beta" into cell A1 was made on 11/1/06 that date would be
recorded in cell B1. The entry in cell B1 is unchanged until the entry in
cell A1 is changed until cell A1 is modified.

Thank You for your help,

Ed

Ed,
You will probably need to use VBA for this and hence you will have more luck
wth the answer if you ask the question in that (Excel.Programming) group.
Alok

"Ed" wrote:

Is there a function or formula for 19 used to record the date the contents of
another cell are modified? For example, if the entry in cell A1 is "beta"
and the entry of "beta" into cell A1 was made on 11/1/06 that date would be
recorded in cell B1. The entry in cell B1 is unchanged until the entry in
cell A1 is changed until cell A1 is modified.

Thank You for your help,

Ed

As Alok suggests, you would need VBA event code to do the job.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then
'change range to suit
With Target
If .Value < "" Then
.Offset(0, 1).Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End If
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

This is event code. Right-click on the sheet tab and "View Code".

Copy/paste the above into that sheet module.

Enter anything in A1 and the date will be entered into B1

Note: as written it works on any cell in the range A1:A10.


Gord Dibben MS Excel MVP

On Fri, 1 Dec 2006 17:14:00 -0800, Ed wrote:

Is there a function or formula for 19 used to record the date the contents of
another cell are modified? For example, if the entry in cell A1 is "beta"
and the entry of "beta" into cell A1 was made on 11/1/06 that date would be
recorded in cell B1. The entry in cell B1 is unchanged until the entry in
cell A1 is changed until cell A1 is modified.

Thank You for your help,

Ed