Multiple selection in Combo/List box

  • Thread starter Thread starter SoNew2This
  • Start date Start date
S

SoNew2This

Is there a way to select multiple entries in a Combo or List box? I currently
have a Range that is displayed and the user can select one item at a time. It
would be much more efficient if the user could select multiple items.

Thanks
 
Not in a combobox.

But yes in a listbox.

If it's on a worksheet--either a listbox from the Forms toolbar or a listbox
from the control toolbox toolbar, you'll need code to retrieve the values.

Same if it's on a userform (within the VBE).

So where is it and what kind is it?
 
It's on a worksheet. it's in column B and there may be 100 rows. I created a
Range called listMeds. I did find code in this News Group to create the combo
box and populate with values, but I'm really new to all this programming and
need guidance. I've created a user form that containds the Combobox and a
Save and Cancel button. When the medication is selected it is copied to
another sheet called TailorItems.

Thanks again,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box 2
Having trouble with combo boxes. 11
Combo Box and Multiple row / column display 2
Combo Box Unique Entries 1
Combo box, select item, auto create another combo box in field 2
finding line number selected in combo box 5
Close form when I press enter 1
Disabling the Combo Box 6

Back
Top