Searchable combo-box in user-form

Hi expert,

I have user form with dependant combo boxes 1 (txtProblem) . In which this combo box will list down data based on combo box 2 (txtMachine). I want vba or macro to make combo boxes 1 (txtProblem) searchable just like google search suggestion based on combobox 2 (txtMachine)
Please see attached file.
ex. Sheet 3 is where the data for combo box

Please help me if have any way to make it searchable.

Thank you for advance help.

It seems that the columns of sheet 3 have no relationship to each other.
What is the relationship between Machine and Problems?

For example,
- what values should be listed with Machine DIFFUSION ?
- what values should be listed with Machine SELA ?
- what values should be listed with Machine ANNEALING ?

Hi, Cyril Beki
I suggest you don't use 'rowsource' to populate the combobox list , because it's unreliable, sometimes it makes the Excel crash.
Please check this:
http://www.snb-vba.eu/VBA_Fill_combobox_listbox_en.html
"If you use 'rowsource' you make a direct link to a certain range in a worksheet.
Combined with the combobox it can cause Excel to blackout, because any change in the combobox will be transferred directly to the 'source'.
Excel has proven not to be able to do this correctly.
Besides: the changing of the source at every change in the combobox slows down your code.
You should reduce the reading/writing from/to a workbook in your code as much as possible."

and this:
https://www.excelforum.com/excel-pro...ml#post5211269

You can populate the combobox like this:

Me.Combobox1.List = Sheets("Sheet1").Range("A1:C100").Value

OR

Me.Combobox1.List = Sheets("Sheet1").ListObjects("Table1").DataBodyRange.Value

what about the searchable combobox ? Because i really need it since it will quicken my time to pick any required data