fixed date and time stamp

  • Thread starter Thread starter Chris Orchard
  • Start date Start date
C

Chris Orchard

I am running Excel 97 SR2. I have tried to use the NOW()
function to put a FIXED date and time stamp in a cell, but
the time keeps updating everytime the cell is clicked into
again or the sheet is autocalculated.
I want a macro that will enter a FIXED date and time stamp
(in all cells within one column that I have
called 'Date/Time Incident Occurred') whenever these cells
are clicked on, or entered via the tab key or arrow keys.
 
How about:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target
As Excel.Range, Cancel As Boolean)
If Target.Column = 1 Then
Target.Value = Now
Cancel = True
End If
End Sub
 
Back
Top