Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box multi-select
I need a multi-select combo box w/ drop down. Is there one out there?
Thank you, -- Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box, select item, auto create another combo box in field | Excel Programming | |||
How to Pre-Select items in Multi-Select List on Form | Excel Programming | |||
code to parse a multi-colum multi-select listbox | Excel Programming | |||
Multi-select Combo Box | Excel Programming | |||
Extract values from a multi-select multi-column list-box | Excel Programming |