Recording the date another cell is edited or modified.

G

Guest

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
 
G

Guest

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top