Search for file names and list them in column A

Hello everyone
The following masterpiece of code is Mr. Leith Ross's code. It searches for specific file names that contain specific string

Please Login or Register  to view this content.

It works fine but I need to add flexible way to be able to search for more than a string ..
for example if I have a file name "Copy Non-Contiguous Columns To Another Sheet In Different Order"
If I searched the string 'non' it is ok and the file name appears in results
If I searched the string 'order' it is ok and the file name appears in results
But if I searched 'non order' the file name doesn't appear in results ...!!and this is the problem for me

I mean it is ok if I used one string
I need it to be flexible that I need sometimes to type two ot three or more strings ..
So as in example I need to the file name "Copy Non-Contiguous Columns To Another Sheet In Different Order" to appear in results if I typed in inputbox the string 'order non copy' .. the order of strings may be from right to left or from left to right or scrambled ..and the case of letters is not sensitive

Thanks advanced for help

Does putting the string like this help any?

Please Login or Register  to view this content.

Thanks Dave for quick reply
This method doesn't work .. or you mean you can edit the code so as to be able to search for file names using this method ..if so ok no problem using this method

Thank you very much for Mr. Leith Ross for this masterpiece... I appreciate his help in this code as this code is his masterpiece

Are you there Mr. Lewis?
May you have a look at the code ..and tell me if my request is possible or not?

Hello Yasser,

Yes, Yasser it can be done. To use multiple words in the title, I would need to create a UserForm to accept multiple search words and options. The UserForm inputs would then be used to create the FileFilter.

Thanks a lot for reply Mr. Leith
But I don't need results to appear on userform .. I need the same results in column with hyperlinks to the results ..this saves my time a lot
Or you mean to use userform just for inputs instead of inputbox
Regards

Hello Yasser,

I did mean to use the UserForm just for inputs instead of the input box. It will allow more inputs to be combined in different ways for filtering.

Thanks Mr. Leith for reply
I still wait for your reply
Here's a code that search for all instances in column A and show the cells for results and hide other rows ..
This may help to reach the goal

Please Login or Register  to view this content.

Mr. Leith Ross
Do you remember my thread and working on it ..?
Thank advanced for your help

Bump ... Any help