Charachter limits for drop down box lists

[tbeatty]

I have a list of 802 items but can not for some reason view the item 802 when I go to the drop down box. Is there a limit to how many choices can be available from a drop down box?

Thank you

[teylyn]

Hi,

what kind of list box are you talking? Data validation or combo box? I'm using Excel 2003 and don't have a problem displaying more than 1000 items in either. Can you post a workbook?

[tmanbone]

I encountered the same problem trying to recreate your issue (with a ListBox). Try setting the IntegralHeight property to True and see if you still face issue (that did the trick for me).