+ Reply to Thread
Results 1 to 4 of 4

analogous:Drop Down List

  1. #1
    Registered User
    Join Date
    11-04-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    27

    analogous:Drop Down List

    Can I set up a drop down list (either through data validation or a VBA combo box) so that when the user begins typing the entry it goes to the item beginning with that? I'm thinking of something analogous to a drop down list on a web-based form. My google searches aren't turning up what I need. Thanks in advance.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Drop Down List Question

    Good evening wiL
    Quote Originally Posted by wiL View Post
    Can I set up a drop down list (either through data validation or a VBA combo box) so that when the user begins typing the entry it goes to the item beginning with that?
    the only way to set up a drop down box that will autocomplete is to use the control found on the Control Toolbox toolbar. This is harder to control than its counterpart on the Forms toolbar, but will give you the functionality you require.

    Just make sure that on the properties of the combobox, MatchEntry is set to 1 or 2, not zero. I think that 1 is set by default.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    05-14-2009
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    7

    re: analogous:Drop Down List

    Thank you for reminding of the rules, I will post this as a new thread with link. FWT

    I am relatively new to excel, but have been trying many different and new things as I read about them in the forums here. Unfortunately I don't understand dominicb's response.

    I would like to do something similar to wiL with an employee drop down list. As the user begins to type the name, the drop down would narrow the choices alphabetically or the user could select the drop down list then hit the first letter of the name and go to that letter of the list (i.e. selecting "M" to go to the portion of the list that starts with "M")
    Last edited by flyingwithtwins; 12-31-2009 at 10:47 AM. Reason: Broken Rules

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    re: analogous:Drop Down List

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1