autocomplete drop down

G

Gary

I have a drop down list in a cell containing 25 names from a range list. Is
there a way to make the cell autocomplete once a name begins being typed in
the cell?

Regards,
Gary
 
D

Dave Peterson

Not if you're using data|validation or a dropdown box from the Forms toolbar.

But yes if you're using a combobox from the control toolbox toolbar.
 

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

data validation list 17
combobox 4
Drop-down list and error message 1
Drop Down List 2
Drop Down List Help 4
Excel Excel: How do I put a formula in a drop down list 11
Drop down list from index/match formula 1
Turning on data validation in one cell based on the contents ofanother cell 1

Top