Looking for a Form Control that combines ComboBox and CheckBoxes

[Ayo]

I am looking for a form control that is essentially a combobox with
checkboxes embedded in it. When you click on the dropdown arrow of the
combobox, you get a list of items, each with a checkbox in front of it. The
checkboxes makes multiple selection possible in the combobox.

 

[slarbie]

What you're looking for is a combobox with the ListStyle property set to "1 -
fmListStyleOption". See VBA help entry for ListStyle Property for more
detail on how to use it.

 

[Ayo]

What I was loking for is in the ListBox property but not in the Combox
property. Thanks anyways, for the info. I have to figure out another way to
accomplish what I was intending to do.

 

[Howard31]

Mind you, if you need to have it in a Combobox then you'll have the problem
of multiple selections, which is not compatible with Comboboxes only with
Listboxes.

 

[Rick Rothstein]

First off, the CheckBoxes, in and of themselves, is not what makes a
multiple selections in a ListBox possible... the ListBox's MultiSelect
property is what does that. The problem you are facing is that the ComboBox
does not offer multiple selection as an option. Probably because the entry
in the text field of a ComboBox is meant to indicated to the user the
selection made from its list. If the ComboBox could have more than one item
selected, then the user might be fooled into thinking there was only one
item selected because that is all he/she would be able to see in text field
of the ComboBox.

 

[JLGWhiz]

Why not just put a bunch of checkboxes on a UserForm. When it is time to
make the selections, show the UserForm. When the CheckBox is clicked to
make the selection, Unload the UserForm.