If simplicity is your goal then a data validation list is the way to go.

Why is having to scroll the list such a bad thing?

--
Biff
Microsoft Excel MVP


"Football Express" wrote in
message ...
If the control toolbox is the only way to get all 32 teams into the box I
must use that one. I should say 2 things, The simple drop down would be
good
enough for me but I am attempting to write this program for my Uncle and I
am
afraid he will get discouraged if I don't simplify it. Also, probably
more
importantly the choosen team must be able to be recognized by the vlookup
command.

Thanks again Dr. Valco
--
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...



"T. Valko" wrote:

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...