Searchable combo-box in user-form

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