VBA userform, filter listbox value as the user type in the textbox

I have found a code from this forum made by haripopuri member (I'm sorry as I'm a new member, I'm not allowed to post a link in my post) like this :

Please Login or Register  to view this content.

I don't understand how it works, but anyway after I tried the code, the result is similar to what I'm expecting.

But what I want is actually the userform has one TextBox and one ListBox.
The ListBox I've already populated from a named range (already in a unique value) using ListBox Property "RowSource".
For example, the ListBox (after populated) now show a list :
Apple
Apricot
Approach
Alpine
April
Aladin 100
Aladin 200
Breast
Brown
Bandit

I want those list filtered as I type in the TextBox (update automatically).
For example, when the first character I type in the TexBox is "a" (without apostrophe), then the ListBox show Apple, Appricot, Alpine, Aladin 100 and Aladin 200.

When I continue put one more character "p", so now the TextBox value is "ap" , then the ListBox show Apple, Apricot, Approach
When I continue put one more character "pp", so now the TextBox value is "app" , then the ListBox show Apple, Approach.

If I backspace, deleting the "pp" then put character "L", so now the TextBox value is "al", then the ListBox show Aladin 100 and Aladin 200.
(The filtering is something like when filtering a table in a sheet by using Text Filter option "begins with").

If I delete all the character in the TextBox (so there is nothing there), then the ListBox show all the list value in the named range (default value).
Then ff I type in the TextBox characater "b" (without apostrophe), then the ListBox show Breast, Brown, Bandit.

So, what is the code to "trigger" the ListBox filtered by the value in the TextBox as the user type there ?
Any kind of respond would be greatly appreciated.
Thank you in advanced.

Originally Posted by AlphaFrog

Change the named range to suit.

Please Login or Register  to view this content.

Thank you very much, AlphaFrog.
You really saved my day

Originally Posted by AlphaFrog

You're welcome. Thanks for the feedback.

Bonus filter: If you enter in the textbox *ri, it will filter the list for items that contain ri.

Bonus filter2: Enter ??p and filter the list for the 3rd character p.

Nice and thank you for the bonus filter.
I will remember your bonus filter in case one day I need to do that