item limit for a combobox?
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.
|