Brad:
reference doubleclick event
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''
'if youe Sheet name is "Sheet1"
'Paste in the following code to Thisworkbook
Private Sub Workbook_Open()
Worksheets("Sheet1").OnDoubleClick = "activeTime"
End Sub
'Add a VBA module to your project and add this code to it.
Sub activeTime()
ActiveCell = Now()
End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''
Save and close the workbook
open the workbook again
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Brad K." wrote:
I am trying to put together a sheet that will have several cells that when
double-clicked on, they will put the current time there. (i.e. this is for
timing events as the happen and say cell B3 corresonds to that event, I want
to double-click on it to record when it happend).
Anyone have some ideas on how to proceed?
Thanks,
BradK