combobox filter based on textbox value

Hello,

I have a combobox with values made out off two cells. What I am trying to do is filter the values in the combobox based on my input in a textbox. I made a variant of both and did vbTextcompare. So far so good.

Where I am experiencing troubles is when I want to do the vbTextcompare on multiple 'words' in the textbox1. I have split based on the " " in the textbox. The problem is the code I'm having is more of an OR. If one of the values in the split is present in the combobox-variant then it will be added. What I want is that if ALL the values in the split are present the item will be added to the combobox. How can I do that?

Please Login or Register  to view this content.

You can try using a boolean, check that if one of the comparisons do not match then set it to false. After checking, if the boolean is still true, then add it to the combobox.

Please Login or Register  to view this content.

Thank you. That was the code I was missing in my thinking proces