Looking for a Form Control that combines ComboBox and CheckBoxes


A

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.
 
Ad

Advertisements

S

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.
 
A

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.
 
H

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.
 
R

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.
 
Ad

Advertisements

J

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.
 
Ad

Advertisements


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

Top