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

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

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

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