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

Thank you,

--
Tony

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.


"Tony" <(E-Mail Removed)> wrote in message
news:63293A8B-46E7-4236-8D63-(E-Mail Removed)...
>I need a multi-select combo box w/ drop down. Is there one out there?
>
> Thank you,
>
> --
> Tony

You can find additional info at this site:

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


"Tony" <(E-Mail Removed)> wrote in message
news:63293A8B-46E7-4236-8D63-(E-Mail Removed)...
>I need a multi-select combo box w/ drop down. Is there one out there?
>
> Thank you,
>
> --
> Tony

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

JLGWhiz wrote:
>
> 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.
>
> "Tony" <(E-Mail Removed)> wrote in message
> news:63293A8B-46E7-4236-8D63-(E-Mail Removed)...
> >I need a multi-select combo box w/ drop down. Is there one out there?
> >
> > Thank you,
> >
> > --
> > Tony

--

Dave Peterson

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You sure you're not mixing up the multiselect listbox with a combobox?
>
> JLGWhiz wrote:
>>
>> 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.
>>
>> "Tony" <(E-Mail Removed)> wrote in message
>> news:63293A8B-46E7-4236-8D63-(E-Mail Removed)...
>> >I need a multi-select combo box w/ drop down. Is there one out there?
>> >
>> > Thank you,
>> >
>> > --
>> > Tony
>
> --
>
> Dave Peterson