Howard
I tried it before I sent it and it works for me. I have Excel 2002. Otto
"L. Howard Kittle" wrote in message
...
I don't believe that is a drop down feature.

Perhaps a work-around is to name the various ranges of the A's, B's, C's,
etc. Then in one drop down you would have a list of the named ranges and
another that would produce all the values of the list chosen by the first.

So on the first drop down you choose the R list. Now when you hit the
arrow on the second one you have all the R's available to choose from.

In the source box of the second drop down you would use something like:

=CHOOSE(MATCH(B1,A1:A3,0),letters,numbers,costs)

Where B1 is the first drop down
Where "letters", "numbers", "costs" are named range in A1:A3.

Maybe bunch some shorts lists together like PQ and XYZ.

HTH
Regards,
Howard

"jwfakouri" wrote
in message ...

I have a drop down box that is large. Is there a way if I type the
letter A it will take me to the A's or the letter B and box will go to
the B's.

thanks,
Jason


--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile:
http://www.excelforum.com/member.php...o&userid=31435
View this thread:
http://www.excelforum.com/showthread...hreadid=511392