+ Reply to Thread
Results 1 to 4 of 4

Auto Complete Drown Down list

  1. #1
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Auto Complete Drown Down list

    How can I activate auto fill in a drop down list? My list of providers can be close to 2000 entries.......this could get quiet frustrating for customers trying to scroll through an entire list just to select a name.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Auto Complete Drown Down list

    Try this formula in data validation in G2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And in Data validation, select Error Alert tab and unmark box on top left that says something like "Show Error Alert...", then OK.

    Copy cell G2 down to G7 to apply data validation to other cells.

    Drop down list will show only those values that start with first characters typed.

    Good luck!

  3. #3
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Re: Auto Complete Drown Down list

    Is there a way it could work to also index if criteria is inside the text string?

  4. #4
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Auto Complete Drown Down list

    There may be some VBA solution to match and auto complete drop down list, and hopefully some VBA expert here will help you out.

    To match criteria mid string, I would use a helper column, with this formula say in K2, which will spill down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Then, in Name Manager from the Formula ribbon, create a dynamic range named "Helper", for example, with this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Then in data validation, type:
    =Helper

    The problem with this solution, as you use multiple cells with data validation, each cell would require a new helper column and a new dynamic named range.

    File attached with data validation in G2 only.

    Happy trails!
    Attached Files Attached Files

+ 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. Get data from drown down list in pivot table
    By ndmalam in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-23-2020, 12:38 AM
  2. Auto Complete Drop Down List
    By santhire in forum Excel General
    Replies: 0
    Last Post: 03-29-2016, 01:59 AM
  3. Replies: 0
    Last Post: 12-16-2015, 05:50 AM
  4. Drop drown list input for case statement
    By mhghg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2015, 01:49 AM
  5. Drown Down List on Multiple Sheets
    By mfaustin in forum Excel General
    Replies: 2
    Last Post: 07-25-2013, 04:34 PM
  6. auto complete from Drop down List
    By hel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2010, 12:10 PM
  7. [SOLVED] auto complete in list
    By sedonovan in forum Excel General
    Replies: 6
    Last Post: 06-26-2006, 01:30 PM

Tags for this Thread

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