See Debra Dalgleish's site for method using a combo-box.

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


Gord Dibben MS Excel MVP

On Thu, 2 Nov 2006 09:04:31 -0600, "Brian" wrote:

Howdy All,

I have several cells that have drop down lists associated with them.

What I would like to do is have the cell populate from the drop down list
when the first few letters are typed, even though the value hasn't been
typed previously.

Is this possible?

Thanks,
Brian