I have a userform with a combobox, and also have a spreadsheet "SheetNames" column "A" is a column with various names.
I would like to create a complete high.


example:

I have the following name (spreadsheet "SheetNames" column "A")
ABNER ANTONIO ANDRE DE Moura

I'd like a way I can enter any part of the name.

If I enter ANTONIO, then the code will search all ANTONIO, if you have more than 1 I will bring all if not auto complete ABNER ANTONIO ANDRE DE Moura.

If I enter Moura, then the code will search all Moura, if you have more than 1 I will bring all if not auto complete ABNER ANTONIO ANDRE DE Moura.