Combo box multi-select
 

I need a multi-select combo box w/ drop down. Is there one out there?

Thank you,

--
Tony

Combo box multi-select
 

1. In Excel, you can click on ViewToolBarsControl 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 InsertModule 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 InsertUserForm, 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.


"Tony" wrote in message
...
I need a multi-select combo box w/ drop down. Is there one out there?

Thank you,

--
Tony

Combo box multi-select
 

You can find additional info at this site:

http://support.microsoft.com/kb/161598


"Tony" wrote in message
...
I need a multi-select combo box w/ drop down. Is there one out there?

Thank you,

--
Tony

Combo box multi-select
 

You sure you're not mixing up the multiselect listbox with a combobox?

JLGWhiz wrote:

1. In Excel, you can click on ViewToolBarsControl 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 InsertModule 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 InsertUserForm, 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.

"Tony" wrote in message
...
I need a multi-select combo box w/ drop down. Is there one out there?

Thank you,

--
Tony

--

Dave Peterson

Combo box multi-select
 

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.


"Dave Peterson" wrote in message
...
You sure you're not mixing up the multiselect listbox with a combobox?

JLGWhiz wrote:

1. In Excel, you can click on ViewToolBarsControl 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 InsertModule
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 InsertUserForm, 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.

"Tony" wrote in message
...
I need a multi-select combo box w/ drop down. Is there one out there?

Thank you,

--
Tony

--

Dave Peterson