Auto-Completion on Drop-Down Lists
 

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!

Auto-Completion on Drop-Down Lists
 

A combo box behaves just like that!

Regards,
Stefi

€žA.Chase€� ezt Ã*rta:

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!

Auto-Completion on Drop-Down Lists
 

DV dropdowns do not have autocomplete capability.

See Debra Dalgleish's site for combining DV with a ComboBox.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 04:42:01 -0800, A.Chase
wrote:

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!