View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh Sale Josh Sale is offline
external usenet poster
 
Posts: 177
Default 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