+ Reply to Thread
Results 1 to 2 of 2

How to search/filter data in Excel dropdown having large number of values

  1. #1
    Registered User
    Join Date
    07-17-2007
    Posts
    2

    How to search/filter data in Excel dropdown having large number of values

    Hi,
    I have created a dropdown in Excel 2003 using the menu Data > Validation, Validation Criteria: Allow=List.
    I'm using this dropdown to show a list of employees, which has a few thousand rows. So, obviously it's a bit painful to scroll down the list to select the employee I want.
    Is there a way to enter a few characters of the name, and get a filtered set to values?
    (Please note: this dropdown is one of the columns of an Excel 2003 List. As the number of rows in the list will grow dynamically, these dropdowns will need to be created for each row. So I chose to create the dropdown using Data>Validation, rather than as a combobox form control.)
    Thanks,
    Sam

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    3,903
    Hi Sam,

    A combobox control on a UserForm has an AutoComplete feature, and its dropdown list can display as many rows as you want - this would probably be a significant improvement on the Data Validation approach.

    Let me know if you need further information about this method.

    By the way, are you using the dropdown list to INSERT a name or to LOCATE a name?

    Regards,

    Greg M

+ 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