I would like to get a time stamp that does NOT update upon recalc
"Peggy" wrote in message
...
: Time() returns the current time but upon every keystroke or recalculation
it
: updates. I would like a non-updating time stamp every time I enter a
number
: into an adjacent cell.
:
Try something like this.
Place this formula in the cell you want the time stamp in
=IF(ISBLANK(A1),"",TimeStamp())
replace A1 with the cell you want to use to change the stamp
then create a code module with this function
Public Function TimeStamp()
TimeStamp = Time()
End Function
Paul D
|