Macro for search tool with multiple entries

[bellfano]

Hi guys,
I am looking for a Macro that works similarly (*) to the Excel Searc
tool: you enter a text in the message box and the tool looks in each an
every cell of that sheet and go to the cell/s where it finds the text.
(*) The only diference is that I would like to do a multiple tex
search. For example y would like to be able to enter 2 words (eg. bal
and match) and that excell looks for and go to the cell that have thos
2 words, no matter of their order ball match, match ball, matchball. Th
same for 3 words criteria.
Thank you.
Regards

 

[shanermuls]

Hi guys,
I am looking for a Macro that works similarly (*) to the Excel Searc
tool: you enter a text in the message box and the tool looks in each an
every cell of that sheet and go to the cell/s where it finds the text.
(*) The only diference is that I would like to do a multiple tex
search. For example y would like to be able to enter 2 words (eg. bal
and match) and that excell looks for and go to the cell that have thos
2 words, no matter of their order ball match, match ball, matchball. Th
same for 3 words criteria.
Thank you.
Regards,

A bit delayed but if you still want it - the attached should do the job

I only have it set to search in the current sheet - i thin

+-------------------------------------------------------------------
|Filename: Search for VBA.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=782
+-------------------------------------------------------------------

 

[bellfano]

That´s awsome shanermuls!!
Thank you very much!!!

A bit delayed but if you still want it - the attached should do the job

I only have it set to search in the current sheet - i thin

+-------------------------------------------------------------------
+-------------------------------------------------------------------