| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DoubleClick Method?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DoubleClick Method?
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. -- HTH... Jim Thomlinson "mickey" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DoubleClick Method?
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" wrote: 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. -- HTH... Jim Thomlinson "mickey" wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DoubleClick Method?
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. -- HTH... Jim Thomlinson "mickey" wrote: 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" wrote: 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. -- HTH... Jim Thomlinson "mickey" wrote: 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DoubleClick Method?
Changes can be made to the worksheet from events, which are not in the scope
of UDF's. "Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "mickey" wrote: 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" wrote: 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. -- HTH... Jim Thomlinson "mickey" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use selectionchange instead of doubleclick event? | Excel Discussion (Misc queries) | |||
| ON.DOUBLECLICK function | Excel Discussion (Misc queries) | |||
| doubleclick | Excel Worksheet Functions | |||
| Disable Doubleclick | Excel Programming | |||
| Before DoubleClick | Excel Programming | |||
Linear Mode
