Hi
I used the following FAQ707-1657 to set up a date stamp in Excel when data is entered, this worked fine.
Does anyone know how I can record the time too? At present the date is correct but the time shows as 00:00.
I amended the above FAQ with the .NumberFormat below, but it made no difference:
I don't mind if the time is recorded in the same cell as the date or a different one, but I would like to be able to see both.
Thanks!!
RachieD
I used the following FAQ707-1657 to set up a date stamp in Excel when data is entered, this worked fine.
Does anyone know how I can record the time too? At present the date is correct but the time shows as 00:00.
I amended the above FAQ with the .NumberFormat below, but it made no difference:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
For Each Cell In Target
With Cell
If .Column = Range("G:G").Column Then
Cells(.Row, "F").Value = Int(Now)
.NumberFormat = "MM/dd/yy hh:mm:ss"
End If
End With
Next Cell
End Sub
Thanks!!
RachieD