fixed date and time stamp

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.
 
S

Stephen Bye

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Stamp 1
VLookup IF word in string exists within cell, use the word. 0
making NT user/login user appear in a cell 1
Date & Time Stamp for printing 1
date & time 1
Time/Date Stamp 3
Date and time stamping multiple cells for multiple entries. 1
Time Stamp Issue 10

Top