DoubleClick Method?

[mickey]

Excel help states "this is the same as double-clicking a cell", however it
doesn't appear to initiate either the Worksheet, or Workbook
"BeforeDoubleCLick" events?

Shouldn't the "DoubleClick" method trigger one, or both of the
"BeforeDoubleClick" events?

 

[Jim Thomlinson]

What is being refered to by events is that the workbook or worksheet is
listening for the user to initiate the event and upon catching that event it
executes the code. So when the user double clicks on a cell that triggers the
code to run.

 

[mickey]

Thanks Jim,

I was reading in the MSDN Library, and it says in remarks, under the
"BeforeDoubleClick", that the event is not initiated by the "DoubleClick"
method. Frankly that fact should be clarified in the MS Help on the
DoubleClick method - it's little misleading to say that the method is
"equivalent" to a user double-click.

By the way do you know of a way to initiate an event, other than the
"Calculate" event, under program control?

 

[Jim Thomlinson]

Why would you want to? Double clicking a cell just puts the cell into edit
mode. You can just put a cell into edit mode without worrying about the need
to double click.

 

[mickey]

Changes can be made to the worksheet from events, which are not in the scope
of UDF's.