A data validation drop down will display only 8 items. You can not change
this.

You can use a combo box which let's you set the number of items displayed
but there are 2 types of combo boxes and which is best to use depends. There
is a Forms cb and a Control Toolbox cb.

I use a 17" monitior and the Forms cb with 32 items won't fit on my screen
(at 100% zoom with the cb on row 1) and the list gets truncated. This type
of cb is easier to setup. The Control Toolbox cb does fit all 32 items but
this type of cb is slightly more complicated to setup.

So, which one do you think you need?

--
Biff
Microsoft Excel MVP


"Football Express" wrote in
message ...
I have read the thread intended to answer a question just like this one but
it increased my confusion. Useing Excel 2003 I need a dropdown box that
contains all 32 professional football teams. That part is easy enough and
is
done. BUT I need the same said dropdown to be long enough to show all 32
teams without useing the side scroll. Is it Possible in EXCEL 2003?
I attempted useing the combo box described in the above mentioned thread
bur
failed. If the only solution to my issue is a combo box could you briefly
explain how to make one that contains all 32 teams. I would much rather
the
DropDown approach.

Thanks in Advance
James
--
To those who have helped in the past,
and those who have tried to help, Thank - You...
To those about to rock,
I salute you...