drop down box

[jwfakouri]

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

[Otto Moehrbach]

There is one way to that. Go into your list and insert some entries. Enter
an "A", by itself, in the cell above the first "A" entry. In other words,
the first cell of the entries that start with "A" should be a cell that
contains ONLY an "A". Do the same for the group that starts with "B" (add a
cell that has only "B" 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
"jwfakouri" <jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com> wrote
in message news:jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com...
>
> 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
>

[L. Howard Kittle]

Hey Otto, thats pretty neat. I'll have to file that one away.

Thanks,
Howard

"Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
news:u7Ejdv1LGHA.140@TK2MSFTNGP12.phx.gbl...
> There is one way to that. Go into your list and insert some entries.
> Enter an "A", by itself, in the cell above the first "A" entry. In other
> words, the first cell of the entries that start with "A" should be a cell
> that contains ONLY an "A". Do the same for the group that starts with "B"
> (add a cell that has only "B" 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
> "jwfakouri" <jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com> wrote
> in message news:jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com...
>>
>> 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
>>
>
>

[L. Howard Kittle]

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" <jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com> wrote
in message news:jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com...
>
> 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
>

[Otto Moehrbach]

Howard
I tried it before I sent it and it works for me. I have Excel 2002. Otto
"L. Howard Kittle" <lhkittle@comcast.net> wrote in message
news:7_-dndw1O6mO5XPeRVn-sQ@comcast.com...
>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" <jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com> wrote
> in message news:jwfakouri.2330wa_1139690100.9465@excelforum-nospam.com...
>>
>> 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
>>
>
>