Table search for string

Hello everyone,

I'm new to either VBA programming and this group so greetings.

I have got some problem, seems like it's pretty easy but I can't handle this.

So what I got is:
-ComboBox Microsoft Forms 2.0
-Table1 in another sheet (Columns - Supplier Name; Supplier ID)

ComboBox search by typing works only for first matching signs. I'd like to prepare macro that search through my Table1 for strings. For example Table1 has "BridgeBuild Thomas Label Limited" and I'd like it to search for this record by typing "Thomas Label" which cannot be done for this moment in my ComboBox. I thought about preparing macro that starts with InputBox and someone who is using sheet can type any string he/she wants.

In result I'd like it to return all matching records (all records that contains *Thomas Label*) in Table1 in MsgBox. If it's possible I'd also like it to return corresponding ID that is in Table1.

If there is another/more efficient solution to this problem please tell.

Thank you in advance!

Attachment

Works pretty good, thank you very much!