Recording the date and time when a record is modified

  • Thread starter Thread starter Sheri
  • Start date Start date
S

Sheri

Recording the date and time when a record is modified -
when any information in updated in a range of cells,
record the date and time in another cell.
 
Sheri, here is one way

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'will put date in column B when something is put in A
If Target.Count > 1 Then Exit Sub
If Target.Column = 1 Then
Target.Offset(0, 1).Value = Now()
End If
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top