Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
item limit for a combobox?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
item limit for a combobox?
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
item limit for a combobox?
I am also running xl2000 and I don't have a problem using a named range
either for a Forms combo box or Control Toolbox combo box even if the named range refers to a different worksheet. If the range involves 500 items then I see all 500. I used the following standard dynamic named range formula where cell A1 was blank and cell A2 contained a header. Below this starting in A3 were the 500 items: =OFFSET(Sheet1!$A$3, 0, 0, COUNTA(Sheet1!$A:$A)-1, 1) Are you sure about your formula? If you select Edit GoTo and enter the range name in the Reference list and click OK does it select the entire range? Regards, Greg "KarenH" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort bar chart in excel | Charts and Charting in Excel | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
Does Excel have an item limit when filtering? | Excel Discussion (Misc queries) | |||
Need to sum up numerous columns in different worksheet into 1 | New Users to Excel | |||
Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) |