View Single Post
  #2   Report Post  
shanermuls shanermuls is offline
Junior Member
 
Posts: 20
Default

Quote:
Originally Posted by bellfano View Post
Hi guys,
I am looking for a Macro that works similarly (*) to the Excel Search tool: you enter a text in the message box and the tool looks in each and 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 text search. For example y would like to be able to enter 2 words (eg. ball and match) and that excell looks for and go to the cell that have those 2 words, no matter of their order ball match, match ball, matchball. The 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 think
Attached Files
File Type: zip Search for VBA.zip (20.3 KB, 72 views)