View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default UserForm with ListBox

Hi Otto,

You are looking for the "ListBox1_Click()" event
or
the "ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)" event.
They are found in the form module.

Regards,
Jim Cone
San Francisco, CA


"Otto Moehrbach" wrote in message ...
Excel 2002, WinXP
I have a UserForm with a ListBox and OK and Cancel buttons.
I know how to deal with a selection in the ListBox when the user makes a
selection and clicks the OK button.
But sometime in the past I was able to induce code action with just the
selection of an item (multi-select set to 1) in the ListBox. IOW, there was
no OK button or a need for an OK button.
How do I do that?
Thanks for your help. Otto