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!