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_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?
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_Sinha 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.
Sep 13 2022 04:17 AM
Hi,
This is rizwan shaikh from osmanabad i am user of microsoft excel from decades
could you add new feature of auto complete cell value and it should show me a list content in that column
this feature has in WPS speadsheet
This my suggestion or feedback for you
Thanking you
my email is email address removed for privacy reasons
Nov 21 2022 02:44 PM
In case anyone needs it, I just shared a new version of "Search deList" add-in, i.e Search_deList_v2.1.
Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.
By using this add-in, you don't need VBA to have this searchable combobox, so you can save your files as .xlsx.
This new version has some additional features, some of them:
- Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
- Sort the list by original order or ascending order.
- Widen or shorten the combobox width at run time.
- Insert multiple entries into the cell.
You can find it here (please check post #81):