validated lookup

[alex]

Hello experts,

I have a list that I'm using as part of a validation function. The
list is in the same spreadsheet; I just hide it off to the side.

The list works well and the user can select from the list (drop down)
or type in the value (as long as it matches the list). I would like,
however, for the list to auto populate when the user starts typing.

E.g., if Simpson is on my list, I want it to pop up when the user
starts typing S-much like an Access combo box. Thanks for any help.

alex

 

[Toppers]

Combo box from Control Toolbox will do this.

Right click on combo box, select Porperties and set ListFillRange to your
list.

HTH

 

[alex]

thanks for the response.

i think the combo box may be too much for what i'm trying to do. i
need a drop down list for every cell in a particular column.
this option looks a little messy.

alex

 

[Debra Dalgleish]

If you can use programming, there's a sample file here that provides 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