Forum Discussion

Heather_Hagart's avatar
Heather_Hagart
Copper Contributor
Mar 09, 2021

Auto complete text in a drop down list cell

Hi everyone,    Trying to do a spreadsheet and figured out how to make the drop down list box (yay).   But I would like to have the option of auto completion of words when I type a few letters in...
excel
Formulas and Functions
Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Mar 09, 2021

Heather_Hagart 

Excel doesn't allows the drop down to Autocomplete, generally we use for Data Validation. 

 

Therefore you have to work with Combo box, is one of the Active X controls.

 

Please check this link,,, I've shown how to do it all about Autocomplete.

 

Hit this link 

  • Abu_Syafiq's avatar
    Abu_Syafiq
    Copper Contributor
    Feb 28, 2022

    Rajesh_Sinha 

    i have succesed created a list combo box (Active X Control) and vba code :

     

    Private Sub ComboBox1_Change()
    ComboBox1.ListFillRange = "DropDownList"
    Me.ComboBox1.DropDown
    End Sub

     

    and the combo box like this :

    but if i want to select the list data below by arrow (on the keyboard), excel in error  like this :

     

    how to solved this problem..?

     

  • Liz204's avatar
    Liz204
    Copper Contributor
    Aug 06, 2021

    Rajesh_Sinha 

     

    Hi,

     

    I am trying to use this, but the sheet I want it to autocomplete is a different sheet from the one where the list is.  So I have a column in August that I want to populate with employees names.  The list in in sheet settings under D2:D65.

    I can't seem to make this work at all, and I need to be able to give me the employees quicker so I can do data entry on the August sheet. 

    Can you make this work when I don't know VBA?

    Thanks,

     

    Liz

     

    • Rajesh_Sinha's avatar
      Rajesh_Sinha
      Iron Contributor
      Aug 07, 2021
      Without VBA this will hardly work,,, you do one thing,, upload the WB and mention in which column or cell you want to use it then I'll apply the VBA and send back the sheet to you ☺
      • AmyEH's avatar
        AmyEH
        Copper Contributor
        Jan 14, 2022
        Rajesh_Sinha I saw your reply here and wonder if you'd be able to add VBA to my file as well? I also would like to allow auto complete text in a drop down list cell. Thank you!
  • Heather_Hagart's avatar
    Heather_Hagart
    Copper Contributor
    Mar 09, 2021

    Rajesh_Sinha I followed along well until it said "reach to linked cell ..." sorry.

     

    I have my Data on one sheet, and the form on the other.  How do I link it from sheet 3 (data) to be on the combo box on sheet 1?

     

    Or no no?

    • Daajkvar's avatar
      Daajkvar
      Copper Contributor
      Jan 07, 2022
      Have you tried with VLOOKUP, or even better, XLOOKUP to link different sheets? They worked great for me. Good luck with that 🙂
    • Rajesh_Sinha's avatar
      Rajesh_Sinha
      Iron Contributor
      Mar 10, 2021
      The link I've show with my post has solution,,,, and it's properly elaborated,, unable to realize that where U got stuck,,, if possible better share the Workbook with me and let me examine it to Fix.

Resources