Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Form Control that combines ComboBox and CheckBoxes
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Form Control that combines ComboBox and CheckBoxes
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" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Form Control that combines ComboBox and CheckBox
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. "slarbie" wrote: 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" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Form Control that combines ComboBox and CheckBox
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. "Ayo" wrote in message ... 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. "slarbie" wrote: 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" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Form Control that combines ComboBox and CheckBoxes
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. -- Rick (MVP - Excel) "Ayo" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Form Control that combines ComboBox and CheckBox
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. "Ayo" wrote in message ... 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. "slarbie" wrote: 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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form control combobox | Excel Discussion (Misc queries) | |||
How do I add a control check box to control other checkboxes? | Excel Worksheet Functions | |||
Disable and enable dropdown combobox(Form Control) | Excel Discussion (Misc queries) | |||
Disable Dropdownlist (Combobox - "Form Control") | Excel Programming | |||
Control checkboxes | Excel Programming |