Mar 08 2021 04:48 PM
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 instead of scrolling down the list every single time (for the most frequent ones I use).
Is there a way I can do this please?
My automatic cell completion is turned on, and works for non-list cells.
Thanks to all the brains that can help me out
Mar 08 2021 11:06 PM
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.
Mar 09 2021 01:47 AM
@Rajesh-S 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?
Mar 10 2021 04:11 AM
Mar 10 2021 04:34 AM
Mar 10 2021 04:44 AM
Here dropdown with ComboBox where it reacts to the letter input.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Aug 06 2021 09:35 AM
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
Aug 06 2021 11:54 PM
Aug 08 2021 11:20 AM
@Rajesh-S Great! I will do that tomorrow. Thanks! Liz
Jan 06 2022 04:04 PM
Jan 14 2022 11:49 AM
Feb 27 2022 10:50 PM
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..?
Mar 28 2022 03:59 AM
Apr 02 2022 07:56 PM
This "Search deList" add-in is actually pretty good. It gives you a unique, sorted & non-blank list in the combo box.
It also works without lag on large list, I tried it on about 12K rows of data.
Thank you for the info.