Time stamp

  • Thread starter Thread starter TimE
  • Start date Start date
T

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
 
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.
 
Back
Top