View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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