+ Reply to Thread
Results 1 to 2 of 2

Drop down list that only shows matches to what is typed

  1. #1
    Forum Contributor
    Join Date
    05-20-2008
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    174

    Drop down list that only shows matches to what is typed

    Hi,

    Is it possible to use data validation on a cell that as you begin to type what you want, a list of all possible matches from a list appears in a drop down list to choose from?

    EG
    List

    Cole
    Coope
    Cooper
    Cummings

    As you start to type the 'C', the entire list above would appear. When you then type 'O', Cummings would drop off the list etc etc.

    I may be asking for the impossible, I really don't know.

    Thanks in advance.

    AM

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See if links help

    http://www.contextures.com/xlDataVal10.html
    http://www.ozgrid.com/Excel/autocomplete-validation.htm

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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