Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down Lists and Auto Fill Ken New Users to Excel 6 December 14th 09 06:34 PM
Screen Tip/Auto Completion For UDFs FARAZ QURESHI Excel Discussion (Misc queries) 1 March 7th 09 07:43 AM
auto completion anirban Excel Discussion (Misc queries) 5 January 20th 09 12:23 AM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
Multiple lists with repeated values for dependet drop down lists mcmanusb Excel Worksheet Functions 1 September 29th 06 12:13 AM


All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"