First double-click lost?
I have an Excel application that includes a form with a couple of listboxes
and command buttons. For one of the listboxes I want to capture both
single-click and double-click events. So I have a bit of code like:
Private Sub lstMemberList_Change()
...
End Sub
Private Sub lstMemberList_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
...
End Sub ' lstMemberList_DblClick
If I launch the form, single-click an item and then double-click the same
item everything works OK.
If I launch the form, single-click an item and then double-click some other
item everything works OK.
However, if I launch the form and then immediately double-click an item I
get the Change event but never get the DblClick event. A subsequent
double-click in this same launch of the form works OK.
So it appears that the first double-click on the listbox after the form is
launched is lost. I tried recoding the Change event to a Click event and
that didn't make any difference. I've tested this in XL97 and 2003 with the
same results.
Any thoughts?
TIA,
josh
|