| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit to the length of a list in a combo box
I have a list of around 850 products which i need to list in a combo box.
I have everything working but when i go into the list it is only showing around 100 of the list. Is there any way of increasing how many list entries you can have in the combo box? thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limit to the length of a list in a combo box
I put a combobox from the control toolbox toolbar on a worksheet.
I assigned its .listfillrange property to A1:A1300 and all 1300 showed up in the dropdown. How did you set up your combobox? Fraser B wrote: I have a list of around 850 products which i need to list in a combo box. I have everything working but when i go into the list it is only showing around 100 of the list. Is there any way of increasing how many list entries you can have in the combo box? thanks in advance -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limit to the length of a list in a combo box
the only difference to what you have done is that i have my list in a named
range as apposed to the cell selection. "Dave Peterson" wrote: I put a combobox from the control toolbox toolbar on a worksheet. I assigned its .listfillrange property to A1:A1300 and all 1300 showed up in the dropdown. How did you set up your combobox? Fraser B wrote: I have a list of around 850 products which i need to list in a combo box. I have everything working but when i go into the list it is only showing around 100 of the list. Is there any way of increasing how many list entries you can have in the combo box? thanks in advance -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limit to the length of a list in a combo box
How did you name that range?
My bet is that you used some sort of dynamic range name and you used =counta() in that formula. And you have empty cells in that range. Am I close? If you hit F5 (Goto) and type the name of the range, is the selection what you expected? Fraser B wrote: the only difference to what you have done is that i have my list in a named range as apposed to the cell selection. "Dave Peterson" wrote: I put a combobox from the control toolbox toolbar on a worksheet. I assigned its .listfillrange property to A1:A1300 and all 1300 showed up in the dropdown. How did you set up your combobox? Fraser B wrote: I have a list of around 850 products which i need to list in a combo box. I have everything working but when i go into the list it is only showing around 100 of the list. Is there any way of increasing how many list entries you can have in the combo box? thanks in advance -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Criteria length limit in SUMIF() | Excel Worksheet Functions | |||
| setting a cell length limit | Excel Discussion (Misc queries) | |||
| Text length limit | Charts and Charting in Excel | |||
| Filiter and Limit selection in Combo box / List Box in the UserFor | Excel Worksheet Functions | |||
| Limit to string length in search@replace? | Excel Discussion (Misc queries) | |||
Linear Mode
