Combobox Multiple Selection

I don't think Excel Userform Combobox supports mutli-select (I believe Access 2007 introduced it, but it breaks first normal form of db structure... but that's another story).

I'd recommend using ListBox instead with multi-select turned on.

Sorry, can't help you there.

Originally Posted by Mahmoudelnemr

Listbox is a good option , but theres no place for listbox for every combobox

How about something where the ListBox is hidden.
The ComboBox Drop Button Click event makes it visible
The ComboBox Exit event hides it again.

The ListBox(s) don't clutter up the userform, they are only visible when the ComboBox drop down would have been.

I'll get back to this later this evening and post an example.

Sorry for the delay. I learned some things.

I had suggested a ComboBox+ListBox solution. But... when a combobox list is dropped down, it appears over all the other controls, so the ListBox cannot substitute for the dropdown, because the Listbox would be partially hidden.

A ComboBox is a mix between a TextBox plus a list, where the user can either type the entry or select one item from a list.
You want a multi-select option.
So I created a custom control, clsMultiCombo, that combines a textbox and a ListBox to get that result.

The .AddItem, .List, .ListIndex, .RemoveItem and .Selected properties (and others) of the clsMultiCombo mimic those of a ComboBox.

There are a few properties and methods that are unique to a clsMultiCombo:

.DropUp - closes the drop-down list

.TextDisplayMulti - when the list is dropped up, if .TextDisplayMulti is False, the textbox will show the first selected item from the list. If True (the default), it will display a delimited string of all the selected items

.Delimiter - is the delimiter used to create that delimited string. The default value is " ", but can be changed.

The .Value property of clsMultiCombo is the delimited string of all selected items.
The .Text property is the string currently displayed in the TextBox. Note the .Value and the .Text are the same if .TextDisplayMulti is True.

The .MultiLine property of clsMultiCombo is sort of an Auto-Height for the textbox. (default - False)
if .MultiLine = True the textbox will expand in height to show all of the .Text value
if .MultiLine = False the textbox will retain its size and some might run out the sides.

The attached file has a userform with a clsMultiCombo control and some other controls to show how these properties work.

To use clsMultiControl, one creates an instance and then sets the .TextBox property to an existing textbox.
Only after the .TextBox property is set does one start filling boxes etc.

NOTE: a ComboBox allows for the user to type into the box as well as select a single item from a list. But with multiple selection, how to interpret user typed values is a problem. So, currently, clsMultiCombo will only accept selection from the list. Typing into the textbox has no result. i.e. the .Style is fixed at fmStyleDropDownList.

NOTE 2: custom classes do not respond to Exit, BeforeUpdate or AfterUpdate events. So clsMultiCombo does not "know" for sure when the control has the focus, which leaves the dropdown list open. To close the dropdown list, the user either clicks on the drop button or they tab out of the control.