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