| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mouse double-click to select listbox item and run userform
Excel 2007 and XP Pro:
I have a UserForm with several list boxes. Normally I select items from relevant listboxes and press OK button to continue with the macro. Can I do the same by just double-clicking on any item of any listbox in the Form, that is, combining list item selection and pressing OK into one double-click? Regards, Lemi |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse double-click to select listbox item and run userform
There is no double-click event, but you could measure the time between 2
click events or mouse-down events and make your own double-click. How about triggering the action with a right mouse-down? RBS "Lemi" wrote in message ... Excel 2007 and XP Pro: I have a UserForm with several list boxes. Normally I select items from relevant listboxes and press OK button to continue with the macro. Can I do the same by just double-clicking on any item of any listbox in the Form, that is, combining list item selection and pressing OK into one double-click? Regards, Lemi |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse double-click to select listbox item and run userform
Hi RBS,
Thank you. However I have just found out that there was double-click event. See below: Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) UserForm1.Hide 'put here exactly whatever your OK button does End Sub It works.. Lemi "RB Smissaert" wrote in message ... There is no double-click event, but you could measure the time between 2 click events or mouse-down events and make your own double-click. How about triggering the action with a right mouse-down? RBS "Lemi" wrote in message ... Excel 2007 and XP Pro: I have a UserForm with several list boxes. Normally I select items from relevant listboxes and press OK button to continue with the macro. Can I do the same by just double-clicking on any item of any listbox in the Form, that is, combining list item selection and pressing OK into one double-click? Regards, Lemi |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mouse double-click to select listbox item and run userform
Ah, yes it has! Nice and simple then.
RBS "Lemi" wrote in message ... Hi RBS, Thank you. However I have just found out that there was double-click event. See below: Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) UserForm1.Hide 'put here exactly whatever your OK button does End Sub It works.. Lemi "RB Smissaert" wrote in message ... There is no double-click event, but you could measure the time between 2 click events or mouse-down events and make your own double-click. How about triggering the action with a right mouse-down? RBS "Lemi" wrote in message ... Excel 2007 and XP Pro: I have a UserForm with several list boxes. Normally I select items from relevant listboxes and press OK button to continue with the macro. Can I do the same by just double-clicking on any item of any listbox in the Form, that is, combining list item selection and pressing OK into one double-click? Regards, Lemi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double click item in Listbox to select item and close Listbox | Excel Programming | |||
| Need selected item from listbox after double click | Excel Programming | |||
| I want open file for click double mouse | New Users to Excel | |||
| Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
| select row in userform listbox with right-click? | Excel Programming | |||
Linear Mode
