validated lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alex - 23 Feb 2007 19:05 GMT

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

Reply to this Message

Toppers - 23 Feb 2007 19:16 GMT

Combo box from Control Toolbox will do this.

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

HTH

> Hello experts,
>
[quoted text clipped - 9 lines]
>
> alex

Reply to this Message

alex - 23 Feb 2007 20:00 GMT

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

Reply to this Message

Debra Dalgleish - 23 Feb 2007 21:56 GMT

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

> 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.
[quoted text clipped - 5 lines]
> 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.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message