drop down list in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

B9 - 18 Nov 2005 02:16 GMT

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.

Reply to this Message

Peo Sjoblom - 18 Nov 2005 02:26 GMT

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

Signature

Regards,

Peo Sjoblom

(No private emails please)

>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.

Reply to this Message

Debra Dalgleish - 18 Nov 2005 03:41 GMT

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

> 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.

Signature

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

Reply to this Message