UserForm Combobox Wild Search Filter based on first letter entry

[Excelnoub]

Good day,
I am looking to modify my combobox from a userform to Filter the list based on the first entry on what the user will add.

I have a code that will search for all entries in my "Control" sheet and passed this on to my combobox:

Please Login or Register  to view this content.

I have, within a module, the following function code that will help the user find the entry by adding the first 3 letters of the search they need:

Please Login or Register  to view this content.

I would like to know what to change in the function to filter the list, once the user adds a first letter and then press the dropdown from the combobox, to filter the list based on all entries from the first letter to only show entries with that letter.

If A is entered, then, show only the entries strating with the starting letter A, but at the same time if the user adds more letter to filter to the first then second letter:

If AB is inserted, then, show entries with AB only.

Where do I add this code also, is this another function or this could be inserted within my function?

[haripopuri]

Without adding any other code, you can just change the MatchEntry property of combo 0- fmMatchEntryFirstLetter. This would show the possible option in the combobox field, and dropdown options will start showing from that option. Have a look at this and let us know if you still want to continue with question above.

[Excelnoub]

Well The MatchEntry property of combo 0- fmMatchEntryFirstLetter doesn't allow other entry pass the first letter...My Function, you can add Letter 1, 2 and 3 and it will filter until the name is reached.
What I was looking for is a filter like process.
Example: If the letter A is entered in my combobox to show only a list with the entries starting with the letter A... If AB if inserted then drills down the list with entries found with AB....

Adam 001
Adam 002
Apple 001
Apple 002
Banana 001
Banana 002
Orange 001
Orange 002

If A is inserted in the Combobox the list should only have the following list:

Adam 001
Adam 002
Apple 001
Apple 002

If Ap is inserted in the Combobox the list should only have the following list:

Apple 001
Apple 002

[haripopuri]

See if this one works for you.

[Excelnoub]

Works very good :D now will try to incorporate this in my workbook and let you know of my final code

Thank you haripopuri

[haripopuri]

Glad I could help you. If you problem is solved, update the thread as solved and you may wish to add to my rep by clicking star at the bottom of each post.

[Excelnoub]

I am just trying to bind your code to my UserFrom and maybe... Maybe try to add it as a function to the following:

Please Login or Register  to view this content.

PS: your rep has already been applied

[Excelnoub]

haripopuri,
just to let you know that I have found something, I don't quite remember how I got it, but here is a sample workbook with a sort of search I was looking for

I will try to change the listbox function to a ComboBox.

WildCardListbox.xls