Auto-Completion on Drop-Down Lists

A

A.Chase

I am creating a payment request form for our accounts department at work, and
one of the columns is for "account name," which we presently have linked via
a drop-down list to another sheet by that name. Ideally, I'd like for
employees to be able to just type the first letter of their account name in
the drop-down box and have it auto-complete, as there are several hundred
entries to scroll through. Is this possible? Right now, auto-complete only
reads the cells in that column on the same sheet, which are not applicable.
I've already alphabetized the list for easier access, but is there anything
further I can do to make the process simpler and less time consuming for them?

Thanks!
 
S

Stefi

A combo box behaves just like that!

Regards,
Stefi

„A.Chase†ezt írta:
 

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

How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Auto populate value from one task to another in MS PROJECT 0
Drop down list control value in vba 2
Help with drop down selection and populating related data... 9
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Filtered drop down list 2

Top