software

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: www.excelforum.com/member.php...oamp;userid=31435
View this thread: www.excelforum.com/showthread...hreadid=511392There is one way to that. Go into your list and insert some entries. Enter
an quot;Aquot;, by itself, in the cell above the first quot;Aquot; entry. In other words,
the first cell of the entries that start with quot;Aquot; should be a cell that
contains ONLY an quot;Aquot;. Do the same for the group that starts with quot;Bquot; (add a
cell that has only quot;Bquot; in it, no quotes). Do this for every letter.
Now, if you type, say, a G, and click on the down arrow, the list displayed
will start with that cell that has only G in it. HTH Otto
quot;jwfakouriquot; gt; wrote
in message ...
gt;
gt; I have a drop down box that is large. Is there a way if I type the
gt; letter A it will take me to the A's or the letter B and box will go to
gt; the B's.
gt;
gt; thanks,
gt; Jason
gt;
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=511392
gt;
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 quot;lettersquot;, quot;numbersquot;, quot;costsquot; are named range in A1:A3.

Maybe bunch some shorts lists together like PQ and XYZ.

HTH
Regards,
Howard

quot;jwfakouriquot; gt; wrote
in message ...
gt;
gt; I have a drop down box that is large. Is there a way if I type the
gt; letter A it will take me to the A's or the letter B and box will go to
gt; the B's.
gt;
gt; thanks,
gt; Jason
gt;
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=511392
gt;
Hey Otto, thats pretty neat. I'll have to file that one away.

Thanks,
Howard

quot;Otto Moehrbachquot; gt; wrote in message
...
gt; There is one way to that. Go into your list and insert some entries.
gt; Enter an quot;Aquot;, by itself, in the cell above the first quot;Aquot; entry. In other
gt; words, the first cell of the entries that start with quot;Aquot; should be a cell
gt; that contains ONLY an quot;Aquot;. Do the same for the group that starts with quot;Bquot;
gt; (add a cell that has only quot;Bquot; in it, no quotes). Do this for every
gt; letter.
gt; Now, if you type, say, a G, and click on the down arrow, the list
gt; displayed will start with that cell that has only G in it. HTH Otto
gt; quot;jwfakouriquot; gt; wrote
gt; in message ...
gt;gt;
gt;gt; I have a drop down box that is large. Is there a way if I type the
gt;gt; letter A it will take me to the A's or the letter B and box will go to
gt;gt; the B's.
gt;gt;
gt;gt; thanks,
gt;gt; Jason
gt;gt;
gt;gt;
gt;gt; --
gt;gt; jwfakouri
gt;gt; ------------------------------------------------------------------------
gt;gt; jwfakouri's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=31435
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=511392
gt;gt;
gt;
gt;
Howard
I tried it before I sent it and it works for me. I have Excel 2002. Otto
quot;L. Howard Kittlequot; gt; wrote in message
...
gt;I don't believe that is a drop down feature.
gt;
gt; Perhaps a work-around is to name the various ranges of the A's, B's, C's,
gt; etc. Then in one drop down you would have a list of the named ranges and
gt; another that would produce all the values of the list chosen by the first.
gt;
gt; So on the first drop down you choose the R list. Now when you hit the
gt; arrow on the second one you have all the R's available to choose from.
gt;
gt; In the source box of the second drop down you would use something like:
gt;
gt; =CHOOSE(MATCH(B1,A1:A3,0),letters,numbers,costs)
gt;
gt; Where B1 is the first drop down
gt; Where quot;lettersquot;, quot;numbersquot;, quot;costsquot; are named range in A1:A3.
gt;
gt; Maybe bunch some shorts lists together like PQ and XYZ.
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;jwfakouriquot; gt; wrote
gt; in message ...
gt;gt;
gt;gt; I have a drop down box that is large. Is there a way if I type the
gt;gt; letter A it will take me to the A's or the letter B and box will go to
gt;gt; the B's.
gt;gt;
gt;gt; thanks,
gt;gt; Jason
gt;gt;
gt;gt;
gt;gt; --
gt;gt; jwfakouri
gt;gt; ------------------------------------------------------------------------
gt;gt; jwfakouri's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=31435
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=511392
gt;gt;
gt;
gt;