MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Want a date input like =NOW() NOT TO AUTO UPDATE - Want a time Stamp

Posted by Phil on May 16, 2001 2:28 PM

I want to be able to time stamp a cell. I am using a "check box" from the forms menu to set "true" or "false" statements in cell "Z6" then in cell "Z10" I put =IF(Z6=TRUE,NOW(),"Not Stamped").

PROBLEM: When I calculate or enter data in any other cell – cell "Z10" automatically updates with the current date and time (as the NOW statement should).

What can I use to have it update ONLY when I want and not whenever anything is done on the sheet?

Posted by Kevin James on May 16, 2001 5:17 PM


Are you aware of "Ctrl-Shift-:"?

It places a static TimeStamp in the cell(s) of your choice.


Posted by Dave Hawley on May 16, 2001 9:36 PM

Hi Phil

Assign your CheckBox to this macro.

Sub StampTime()

If [Z6] = "True" Then
[Z10] = Now
[Z10] = "Not Stamped"
End If

End Sub

OzGrid Business Applications