Auto Fill from Drop Down list
 

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

Auto Fill from Drop Down list
 

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

Auto Fill from Drop Down list
 

Thanks for the info, Gord.

I'm not sure I'm wanting a combo box, do I need to have one for this to be
possible?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

Auto Fill from Drop Down list
 

If you wish to use a DV dropdown you will have no autocomplete feature.

That was the message I was trying to impart with my first response.


Gord

On Thu, 2 Nov 2006 14:33:54 -0600, "Brian" wrote:

Thanks for the info, Gord.

I'm not sure I'm wanting a combo box, do I need to have one for this to be
possible?


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
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




Gord Dibben MS Excel MVP