This is a ChangeEvent macro to put in the WorkSheet module where you want to
use it. It will put a date/time stamp in the cell to the left of any changed
cell.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Selection.Offset(0, -1).FormulaR1C1 = Date & " " & Time
End Sub

hth
Vaya con Dios,
Chuck, CABGx3



"CMIConnie" wrote:

Is there a way for Excel to input today's date in a cell if the information
in the cell next to it is updated? I am using Excel 2000. Thank you.