Avoid search with wild cars **

Hi I have below code which was made brilliant by Holger (HaHoBe). It works fine. The thing is its used so the user seach in hidden sheets, so they are not able to see all the sheet, because is confidential. They only see what they search for.
But I found out of if I put wild cars in for example the customer number 8 digits and 8 ********. It nearly show all the items of course.
Is it possible in below code to input, so its impossible to use wild cars* for the search?

Please see in the code below thanks

Sincerely Abjac

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi, abjac,

like stated before I would not work with InüputBoxes but have UserForms to make the choices: a listbox to choose which worksheet and 2 boxes filled with the IBANS and customer numbers for that very sheet. That would narrow down the range as only items are searched on sheets that exist and for IBANS and customer numbers avalibale for that sheet as well (an additional plus: as you have two boxes for the areas you could use the Autofilter to copy over the data instead of copying whole rows via Find ).

Ciao,
Holger