| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add Text to Combo box
How do you enter the text or "options" into the combo box list? I was trying
to use the Control Toolbox for this but after reading some other posts wasn't sure if I should be using the Forms Toolbar. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add Text to Combo box
For Control Toolbox:
Right click on the combo box, select Properties and then put a range in the "ListFillRange" option. If your options are in Sheet2 A1 to A10, then ListFillRange=Sheet2!A1:A10 HTH "Newby07" wrote: How do you enter the text or "options" into the combo box list? I was trying to use the Control Toolbox for this but after reading some other posts wasn't sure if I should be using the Forms Toolbar. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the format of text in a combo box | Excel Discussion (Misc queries) | |||
| Possible to wrap text in combo box? | Excel Worksheet Functions | |||
| float Text and Combo box | Excel Discussion (Misc queries) | |||
| remove text that pops up with combo box | Excel Worksheet Functions | |||
| Combo Box - Text Size | Excel Discussion (Misc queries) | |||
Linear Mode
