drop down list in Excel

[B9]

I set up a drop down list in excel and wanted to know if there was a way to
set up a predictive text feature so that i don't have to scroll through the
entire list to select the correct entry. i would like to be able to type in
the first two letters and have the entry appear.

[Peo Sjoblom]

If you use the data>validation it is not built in, you need a combobox from
the control toolbox

--
Regards,

Peo Sjoblom

(No private emails please)


"B9" <[email protected]> wrote in message
news:[email protected]...
>I set up a drop down list in excel and wanted to know if there was a way to
> set up a predictive text feature so that i don't have to scroll through
> the
> entire list to select the correct entry. i would like to be able to type
> in
> the first two letters and have the entry appear.

[Debra Dalgleish]

As Peo said, if you created the dropdown lists by using data validation,
it doesn't support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html

B9 wrote:
> I set up a drop down list in excel and wanted to know if there was a way to
> set up a predictive text feature so that i don't have to scroll through the
> entire list to select the correct entry. i would like to be able to type in
> the first two letters and have the entry appear.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html