Search for String and copy resul as rows to new sheet

HI I have this code. which works fine. It search for a string word and copy the row into a new sheet.
I would like to instead of search for the word in the code to have a text box. and just type the word there. And it will search the same way and copy the results into a new sheet. If it could be extended to cover selected worksheets, it will be even better.
Please havea a look at this code and if some have a suggestion or a finish solution, it would be great.

Sincerely Abjac
Here is the code for the one i have which search for a word put into the macro.

Please Login or Register  to view this content.

Writing this from memory on my phone , but try putting

Please Login or Register  to view this content.

at the top, and then

Please Login or Register  to view this content.

And then replace "Mail Box" in your InStr command with Searchterm.

Oh, and its a good idea to put [CODE] tags on your posts, it makes it easier to read.

If it works, please click the star in the bottom left corner

HI Tried what you say, and the box "Please input a seach term" popped up.
I can input a word there but it dont copy anything into sheet 2.
Even if i input the word as before Mail Box
But it come up with the message " All Matching Data have been copied"

But nothing is copied

So i guess there is missing something, and also that the code for the message box is wrong. would be good to have some like "No match found in sheet" and then also that it dont try copy then.

This is my code now as you suggested.

Please Login or Register  to view this content.

HI I found this solution and it work with the option box. The only thing to make it perfect is to have a less sensitive search. As in below code i have to type the word totally correctly. But would like to have the same possibility, as when i do it with control F. . Any suggestions to that would be highly appreciated. The last i miss to be able to use this. Please have a look at the code below

Thanks in advance

Sincerly abjac

Please Login or Register  to view this content.