Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists and Auto Fill | New Users to Excel | |||
Screen Tip/Auto Completion For UDFs | Excel Discussion (Misc queries) | |||
auto completion | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |