I should mention that I'm using Excel 2000. I double-checked everything
again, even blanked it out and redid it, and the same thing is happening.
Can't find anything on the Microsoft website that gives any kind of limit.



"Tom Hutchins" wrote:

Using Excel 2003, I just filled a range with 500 numbers, named the range
"data", and used it to populate 2 comboboxes on the same sheet. One combobox
was created from the Forms toolbar; the other was created from the Controlbox
toolbar. All 500 entries were displayed in each combobox.

Unless you have a different version of Excel and the issue is related to
that, I suggest you check everything again.

Hope this helps,

Hutch

"KarenH" wrote:

I have a combobox in a worksheet, and the entries are populated from a list
of 365 items in another area of the worksheet.

Only 354 entries are showing up. I am using a named range to populate the
combobox, and I double-checked that the range is correct.

I'm wondering if there is a limit to the number of entries in a combobox in
Excel, but I haven't found anything in the help files that tells me.

TIA for any help.