dropdown menu

[\PA via OfficeKB.com\]

I have a list of over a thousand names in a dropdown menu. I would like to
start typing a name in the cell (in the dropdown menu) and have excel
automatically recognize the name and go to that name in the dropdown menu
before I even finish typing the full name. How do I do this?

thanks.

[Bob Phillips]

Use a combobox, it works that way.

--
HTH

Bob Phillips

""PA via OfficeKB.com"" <forum@OfficeKB.com> wrote in message
news:50EBF401BCE61@OfficeKB.com...
> I have a list of over a thousand names in a dropdown menu. I would like to
> start typing a name in the cell (in the dropdown menu) and have excel
> automatically recognize the name and go to that name in the dropdown menu
> before I even finish typing the full name. How do I do this?
>
> thanks.

[\PA via OfficeKB.com\]

I created a sample combo box with several names to test it. Where is the
option to get autocomplete?

[\PA via OfficeKB.com\]

basically, the "MatchEntry property" option is not there in the Properties
tab. What am I doing wrong?

[Bob Phillips]

We are talking Control Toolbox combo here, not a Forms combo. The
Autocomplete is the default for MatchEntry.

--
HTH

Bob Phillips

""PA via OfficeKB.com"" <forum@OfficeKB.com> wrote in message
news:50EC3E80EA989@OfficeKB.com...
> basically, the "MatchEntry property" option is not there in the Properties
> tab. What am I doing wrong?

[Irene Kral]

if you have got all the names written in some other area, sheet or book
choose all the cells u want to use with lists
then choose
Data -> Validation -> choose list in the first box and fill the third one
with the datarange

""PA via OfficeKB.com"" <forum@OfficeKB.com> wrote in message
news:50EBF401BCE61@OfficeKB.com...
> I have a list of over a thousand names in a dropdown menu. I would like to
> start typing a name in the cell (in the dropdown menu) and have excel
> automatically recognize the name and go to that name in the dropdown menu
> before I even finish typing the full name. How do I do this?
>
> thanks.

[PA via OfficeKB.com]

thanks for the tip - it worked! Now, how do I have the same combo box in a
100 rows without having to manually copy/paste the box in those rows?

Irene Kral wrote:
>if you have got all the names written in some other area, sheet or book
>choose all the cells u want to use with lists
>then choose
>Data -> Validation -> choose list in the first box and fill the third one
>with the datarange
>
>> I have a list of over a thousand names in a dropdown menu. I would like to
>> start typing a name in the cell (in the dropdown menu) and have excel
>> automatically recognize the name and go to that name in the dropdown menu
>> before I even finish typing the full name. How do I do this?
>>
>> thanks.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

[Bob Phillips]

Select all 100 cells, then apply the DV.

--
HTH

Bob Phillips

"PA via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:510718C927E00@OfficeKB.com...
> thanks for the tip - it worked! Now, how do I have the same combo box in a
> 100 rows without having to manually copy/paste the box in those rows?
>
> Irene Kral wrote:
> >if you have got all the names written in some other area, sheet or book
> >choose all the cells u want to use with lists
> >then choose
> >Data -> Validation -> choose list in the first box and fill the third one
> >with the datarange
> >
> >> I have a list of over a thousand names in a dropdown menu. I would like
to
> >> start typing a name in the cell (in the dropdown menu) and have excel
> >> automatically recognize the name and go to that name in the dropdown
menu
> >> before I even finish typing the full name. How do I do this?
> >>
> >> thanks.
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200507/1