How would I freeze the internal clock time in a worksheet or form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for a way to freeze internal clock time captured by "=NOW()" into a cell(s)...
refresh should not rewrite the cell(s) that were captured and stored already..

Is there a way to do this

Thanks

Bra
 
Brad

You can enter the time using CRTL + SHIFT + ;(semi-colon) and it will stay
fixed at that point.

The only other way would involve some type of Event code that would write the
time to a cell when something happens to trigger that Event.

Example..........

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in a cell in Col A
On Error GoTo enditall
If Target.Cells.Column = 1 Then
n = Target.Row
If Excel.Range("A" & n).Value <> "" Then
Excel.Range("B" & n).Value = Now
End If
End If
enditall:
End Sub

Gord Dibben Excel MVP
 
Back
Top