LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stamp a Cell with Time Q Sean Excel Programming 4 September 17th 07 07:27 PM
is it possible to time stamp cell comments? Dave F Excel Discussion (Misc queries) 4 October 6th 06 05:51 PM
is it possible to time stamp cell comments? Kevin B Excel Discussion (Misc queries) 0 October 6th 06 02:58 PM
time stamp a cell that doesn,t change when time stamping another RC Excel Programming 5 October 13th 05 02:52 AM
can you date time stamp entries in excel opinky Excel Discussion (Misc queries) 1 March 17th 05 04:25 PM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"