Debra,

Your Combo Box code worked, but the nested boxes and click-through
requirements to load results to the cell were a bit confusing. I found out
that I could copy/paste the named ranges into rows above my validation
dropdown cells and engage "Pick from drop down list", and the cells would
auto complete. I just hid the rows above (not very elegant, but servicable.

Thanks for your help!

Doug

"Doug Evans (InstantZen)" wrote:

Debra,

THANKS! I'll try this. Hopefully, the next release of Excel will include
this as a standard, or optional feature to the pick from drop-down command.

Thanks to all of you for your quick and considered responses.

Doug

"Debra Dalgleish" wrote:

Data Validation dropdown lists don'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


Doug Evans (InstantZen) wrote:
Gord,

I can't find a way to create the "auto-suggestion" that "Pick From Drop-Down
List..." provides using Data Validation Drop-Down information from Debra's
site. You mention a Drop-Down pick list using Data Validation, which sounds
promising, how do I invoke this?

Thanks!

Doug

"Gord Dibben" wrote:


No, but the same thing can be done using a Data Validation Drop-Down pick
list.

See Debra Dalgleish's site for more info and methods.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

On Fri, 13 May 2005 10:41:03 -0700, "InstantZen"
wrote:


When the (right-click) "Pick From Drop-Down List..." command is used in Excel
to facilitate key-entry, it only works for contiguous entries in cells in the
column above the input cell. blank cells in between break the link.

Is there a way to designate a named range of terms as the basis for the
"drop-down" list?

Microsoft,this should be a standard option!




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