Thread: Mouse double-click to select listbox item and run userform
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lemi Lemi is offline
external usenet poster
  
Posts: 14
Default 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


Reply With QuoteReply With Quote