Time stamp

[TimE]

I would like cell b1 to populated with the current date and time whe
cell a1 is typed in (no longer blank). I would need this date and tim
to remain and not change when the sheet is reopened. Can this be don
without VBA?

Thanks in advance

 

[Frank Kabel]

Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

Though I would not use a circular reference but go the VBA
way

 

[Bob Phillips]

Not really, VBA is best

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Then
Target.Offset(0, 1).Value = Format(Now, "dd mmm yyyy hh:mm")
End If

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.