+ Reply to Thread
Results 1 to 3 of 3

Quickly Selecting Items in a Drop Down List

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    Owen Sound, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    59

    Quickly Selecting Items in a Drop Down List

    I'm not even sure if this is possible. I've tried several things but have had no luch. I have a spreadsheet with several long drop down lists in it. I was hoping to find a way that if I start to typ the names that it will automaticall bring me to the section of the drop down list that matches the letters I am typing. For example one of my lists is employee names so if I start typing in the cell Sue then it will show the name(s) that start with Sue. This may not be possible in Excel but if anyone knows of a way I would much appreciate any assistance.

    Thanks in advance

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,896

    Re: Quickly Selecting Items in a Drop Down List

    What you describe is called AutoComplete, but the normal data validation drop-down does not have that facility. However, as Debra Dalgleish describes here:

    http://www.contextures.com/xlDataVal10.html

    you can use a combo box instead and then you would be able to do what you ask for.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-27-2009
    Location
    Owen Sound, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    59

    Re: Quickly Selecting Items in a Drop Down List

    I have been playing with this for awhile now but her instructions are confusing me. I may be that I am using Office 2007 and she seems to be referring to an earlier version before the ribon was used. She instructs me to create drop down lists with data validation, which is how I have created all of my drop down lists. Each is a named range. She then talks about creating a combo box with code (from what I understand a combo box is a different way of doing a drop down menu so I am not sure is she is saying to use a combo box instead of a drop down list in data validation. If so it is confusing because she instructs me to create drop down lists using data validation). In her little video she says there is a little combo box hidden in the corner with code. I have tried to do this but it is not working. She says once the code is added it will apply to all drop down lists in the entire worksheet so I am obviously doing something wrong. If I am supposed to replace all my drop down menus with combo boxes I am not sure how my formulas will be affected because sever of them are dependent upon the selection of the drop down list. I am not sure if you are able to help but I am attaching my actual workbook. I have just changed the specific names in the drop down lists. If you are able to look at it and tell me what I should be doing it would be much appreciated!

    I realized I uploaded the wrong file previously. I have removed that file and uploaded the correct one.
    Attached Files Attached Files
    Last edited by Squint; 03-17-2014 at 08:53 AM. Reason: Forgot to add workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Drop down list range - how to change each month quickly with VBA?
    By VIK1471 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2013, 03:57 AM
  2. Replies: 1
    Last Post: 09-13-2012, 03:46 PM
  3. Replies: 3
    Last Post: 04-16-2012, 10:14 PM
  4. Creating a drop-down list & selecting multiple items
    By Jamie6521 in forum Excel General
    Replies: 1
    Last Post: 02-08-2009, 02:53 AM
  5. Selecting multiple items in a drop down list
    By ACM-GFT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2008, 01:59 PM

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