Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protected Worksheet, Cell Formatting Lost on Double Click? | Excel Discussion (Misc queries) | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
lost double click ability to open files | Excel Programming |