T
Tony
I need a multi-select combo box w/ drop down. Is there one out there?
Thank you,
Thank you,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JLGWhiz
1. In Excel, you can click on View>ToolBars>Control Toolbox, or Forms. My
personal preference is Control Toolbox.
2. Select the ComboBox by clicking on the icon in the ToolBar and move the
crosshair to the point on the sheet that you want to place the control.
Right click to deposit the control on the sheet.
1. In VBA, from the Excel screen, press Alt + F11 to open the VB editor.
Click on the Help Icon. If the big window is dark, click Insert>Module to
activate a code module.
2. When the help panel opens, type "ComboBox Control" in the search box
and press enter.
3. Click on "ComboBox Control (Forms)" in the help topic panel. This will
display a help file that explains the syntax for using ComboBox in code. It
also has topic links for properties, methods, events, etc.
4. If you want to put a ComboBox on a UserForm, then on the VBE menu bar
click Insert>UserForm, then from the ToolBox, select the ComboBox and place
it on the form.
The multiselect property can be set for the ComboBox created from the Tool
Box by going to the Properties Window and selecting that property on th
Multiselect line.
personal preference is Control Toolbox.
2. Select the ComboBox by clicking on the icon in the ToolBar and move the
crosshair to the point on the sheet that you want to place the control.
Right click to deposit the control on the sheet.
1. In VBA, from the Excel screen, press Alt + F11 to open the VB editor.
Click on the Help Icon. If the big window is dark, click Insert>Module to
activate a code module.
2. When the help panel opens, type "ComboBox Control" in the search box
and press enter.
3. Click on "ComboBox Control (Forms)" in the help topic panel. This will
display a help file that explains the syntax for using ComboBox in code. It
also has topic links for properties, methods, events, etc.
4. If you want to put a ComboBox on a UserForm, then on the VBE menu bar
click Insert>UserForm, then from the ToolBox, select the ComboBox and place
it on the form.
The multiselect property can be set for the ComboBox created from the Tool
Box by going to the Properties Window and selecting that property on th
Multiselect line.
J
JLGWhiz
D
Dave Peterson
You sure you're not mixing up the multiselect listbox with a combobox?
J
JLGWhiz
I'm not really sure what I was thinking. The posting is too ambiguous to
give a real answer to, so I thought I would just lead the OP to the basics
of making a combo bos. It did not enter my mind that multiselect only
applies to the listbox throughout the time I was typing all that stuff.
Hopefully, the OP will discover that as they go through the properties.
give a real answer to, so I thought I would just lead the OP to the basics
of making a combo bos. It did not enter my mind that multiselect only
applies to the listbox throughout the time I was typing all that stuff.
Hopefully, the OP will discover that as they go through the properties.