Time stamp on cell entries
You could use a worksheet change macro and put the time into the comment of
the cell.
Sub worksheet_change(ByVal target As Range)
'
If target.Comment Is Nothing Then
target.AddComment
target.Comment.Visible = False
End If
target.Comment.Text Text:=Format(Now, "DD/MM/YY HH:MM:SS")
End Sub
"fabio" wrote:
Hi
Is it possible to record a time stamp of when an entry is made in a cell. I
want to put together a transcription test whereby a candidate would have to
type into a column a number of character strings from a typed sheet. I would
like to be able to record how long the data transcription takes.
Thanks
G
|