Auto Complete Text from list

Hello, I have a complete column in which I want a list of values to appear. I used data validation to a complete column, but the problem was that there were a lot of values in the list that scrolling through those took a lot of time. So I wanted to use something to autocomplete what I typed from the list of values. I used combo box and it worked fine. But then what the problem was I wanted it to be used on each row of a column separately. by this method it was being used only in one cells and not all the cells in a column. Please help me with the same as its urgent. Thanks.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

I suggest using a combobox that can appear and hide automatically.
I created a combobox that has 2 special behavior:
1. The combobox can appear and hide automatically when you select a cell in a certain range.
2. You can type a keyword in the combobox and the results will be narrowed down as you type.

So you only need 1 combobox for all cells that need to be filled in.
Let me know if you're interested in this approach.
Here's a sample workbook:

Well, it's a bit different.
My approach is:
1. It is only using the combobox while the one that you pointed to is using both data validation & combobox.
2. The list in the combobox will be sorted, unique & has no blank.
3. The searching part is more flexible, because it uses the search pattern *word*word.

Thank you Akuini for the help. I will try this out.

Originally Posted by Akuini

2. The list in the combobox will be sorted, unique & has no blank.

Well, this will raise the run time error when the list contains multiple data types, like string, number.

Ah, you're right, Jindon, this will raise the run time error when the list contains multiple data types, like string, number.
Hopefully that's not the case with OP's data set.
But if that's the case then we can change this line :

in Private Sub ComboBox1_Change()"
change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

in Private Sub ComboBox1_DropButtonClick()
change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Thank you for pointing that out Jindon.

No, that's not how it should...

i.e

Please Login or Register  to view this content.

That explains the error! Its working just fine now. Thank you jindon and akuini for helping me out.

Originally Posted by jindon

No, that's not how it should...

i.e

Thank you Jindon, for your very valuable input. I really appreciate it.