y default, if the user double clicks on a cell then Excel application would
switch into the data entry mode.
In such mode the Excel would wait until the user finishes data entry. However,
right before it goes into such mode the Excel would fire the "before double
click" event. The OnSheetBeforeDoubleClick property provides facilities for
trapping such event.
The signature() function on the picture above reveals that the handler for the
"before double click" event is expected to take two arguments and return a
boolean. If the last executed handler for this event returns True then the
event would be canceled and the Excel would proceed to function as if the user
did not double click. If the last handler returns False then the Excel would
proceed normally.
We supply the example event handler as follows.
At the double click on any cell the ControlShell receives new output and the
Excel does not switch into the data entry mode.
|
