Auto Fill from Drop Down list

B

Brian

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
 
B

Brian

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?
 
G

Gord Dibben

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

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?
Click to expand...

Gord Dibben MS Excel MVP
 
Top