Time stamp when data entered into a cell

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Is it possible to automatically create a time stamp for
when data is entered into a different cell. In Column A I
am collecting data via a barcode reader. For each data
record in Column A I would like to automatically record a
time stamp into Column B of when the data in Column A was
entered. Is this possible?

Mike
 
Mike, try this in the worksheet code

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