Results 1 to 2 of 2

Thread: Auto Complete for Data Validation

  1. #1
    Junior Member
    Join Date
    May 2013
    Posts
    4
    Rep Power
    0

    Auto Complete for Data Validation

    Hi

    How do I have the name appear in the cell C2 (sheet1) from the dropdown list : Example if I type the letters "am" in cell C2 (sheet1) then the name Armandip Sharda should appear and when I hit enter then the name is selected.When letters are typed in C2 (sheet1) then the most appropriate name appears

    Thanks

    IJC
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    There is no built-in way to accomplish this task for Data validation.

    Use could try a ActiveX combo box.

    May be this link will be useful. Auto Complete for Data Validation
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Custom Data Validation :: Using Formulas
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-04-2013, 05:40 PM
  2. Replies: 22
    Last Post: 03-19-2013, 07:57 AM
  3. Auto filter and sum up data
    By Ryan_Bernal in forum Excel Help
    Replies: 6
    Last Post: 01-02-2013, 06:42 PM
  4. Dependent Data Validation (Using Only Formulas)
    By Admin in forum Download Center
    Replies: 2
    Last Post: 10-18-2011, 03:14 PM
  5. Data Validation Dependent Dropdowns
    By Admin in forum Download Center
    Replies: 0
    Last Post: 04-10-2011, 03:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •