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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Created invoices in Excel - not working in Drive 1
drop down list 3
can I autopopulate from a long drop down list in Excel? 2
Dependent drop down dynamic range formula, off sheet. 7
Select from drop down list via typing text? 8
auto populate different cells when selecting from drop down list. 2
customize drop-down box 1

Top