Searchbox/Searchbutton not finding data in userform listbox

I am building a userform to sture/edit/delete/search data. However, I've ran into a problem regarding the search button. I have built a command box that lets me select a certain column in which I want to search. if i select a column I can type in the searchbar and in the box below it live updates as I am typing. if you see the right value you can double click and it copies it to the searchbar. So far so good. However if I now click search it says 'no records found' which it is only supposed to do if there's no actual record with that value. It works for some values of the column 'Dossier' in the real file. But it does not seem to work for other columns at all. Anyone have solution?

Userform code vba (without edit Sub to save space):

Please Login or Register  to view this content.

Module1 Code vba (without the submit Sub to save space):
Question form.xlsmQuestion form.xlsm

Please Login or Register  to view this content.

Hello @Excelhelp_0912.
When the selected column is "Dossier", an exact match filter criteria is used in the following line of code:

Please Login or Register  to view this content.

To troubleshoot this issue, you can try using exact match filtering for all columns, as follows:

Please Login or Register  to view this content.

I checked and now everything is found. Good luck.

Have a trial with the attached - all the code is confined to the UserForm - any questions post back on this site.