+ Reply to Thread
Results 1 to 17 of 17

Creating a smart drop down list

  1. #1
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Creating a smart drop down list

    Hi all,

    I have a drop down list in excel. What do I need to do so that it will automatically take me to the closest/best label on the list when I type just a few first letters?

    Thanks all,
    VBisgreat

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Creating a smart drop down list

    Are you talking about the MatchEntry property of the combobox?
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  3. #3
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Creating a smart drop down list

    I'm not sure what it is, whatever can help me get the the label on my drop down list when I type in a few letters instead of scrolling down and find it on the list. Thanks.

  4. #4
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Creating a smart drop down list

    Look at the MatchEntry property of the combobox. Read the help on it by pressing F1, and let me know if that doesn't resolve your issue.

  5. #5
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Creating a smart drop down list

    For form control direction: I tried to follow the direction and got stuck after the: 4. On the Developer tab, in the Controls group, click Properties .
    Last edited by VBisgreat; 04-06-2011 at 05:38 PM.

  6. #6
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Creating a smart drop down list

    Personally, I only use ActiveX controls so I don't know much about form controls.

  7. #7
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Creating a smart drop down list

    It still doesn't work for me. Sorry I'm pretty new in using excel formula. Thanks for your help.

  8. #8
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Creating a smart drop down list

    If you use a ComboBox from the Control ToolBox the MatchEntry property is set by Default to auto complete.

    Here's a quick example that also uses a Dynamic Named Range to fill the Combobox, the control will try to match as you type.
    Attached Files Attached Files
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  9. #9
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Creating a smart drop down list

    this may work --
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Creating a smart drop down list

    Thanks RoyUK.

    Grizzly6969: That's great, can you show me step by step how to get there? I got a similar list and when I follow your instruction the fomula didn't work. Thanks!!!

  11. #11
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Creating a smart drop down list

    Nevermind, I think it's working now. Thanks all
    I really appreciate your helps.
    Last edited by VBisgreat; 04-07-2011 at 10:33 AM.

  12. #12
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Creating a smart drop down list

    My drop down no longer clickable after I save it and reopen it...
    Attached Files Attached Files

  13. #13
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Creating a smart drop down list

    you had not named the range thats why it vanished
    check this out
    Attached Files Attached Files

  14. #14
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Creating a smart drop down list

    this file should help with your validation
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    03-07-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Creating a smart drop down list

    Quote Originally Posted by grizzly6969 View Post
    this may work --
    Very Clever.
    Thank you, It is just what I was looking for.

  16. #16
    Registered User
    Join Date
    04-21-2014
    Location
    Los Alamos, NM
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Creating a smart drop down list

    I am having the same issue as VBisgreat. I have named ranges as I should, but every time I exit and then re-open the file the "Smart" drop-down list quits functioning and I have to re-activate the Data Validation (no changes - just open DV, select apply to all like cells and click OK.. Any clues why? (I use Excel 2007). This is a template for use by many so I finally just assigned a macro to a button that re-activates the Data Validation. My version of Duct-tape and bailin' wire, which works but certainly is not optimal.

  17. #17
    Registered User
    Join Date
    12-23-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    1

    Re: Creating a smart drop down list

    By this we can search the list starting with that letter that i entered but can we get the drop down if the data contains that letter not as first letter.Please help me..its urgent.Thanks!

+ 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