Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stamp a Cell with Time Q | Excel Programming | |||
is it possible to time stamp cell comments? | Excel Discussion (Misc queries) | |||
is it possible to time stamp cell comments? | Excel Discussion (Misc queries) | |||
time stamp a cell that doesn,t change when time stamping another | Excel Programming | |||
can you date time stamp entries in excel | Excel Discussion (Misc queries) |