Refining Famous Search Engine

Well,

hello guys. I want to make this search engine code a little bit better. I have two main concerns:

1) If the user writes two or more words, e.g., sun moon the search engine will look for all the Data in column B with the word sun and/or moon. It means, instead of using the exactly word (sun moon) written in cells(2,2) it would search separately for each word.

2) This is far more important than the first one: I would like for similar words in the search engine. For example, if the user searches for sum it will return sun anyway, because the words are very similar. But the question is: what is similar? Well, I am asking for any help in a code that I don't have the slightest idea of how to do it.

Thank you very much, in my next post I will have studied more about VBA.

Please Login or Register  to view this content.

Well, I did this

Please Login or Register  to view this content.

But the result is being rewritten. Any suggestions?

This line of decides the type of match you are looking for

Please Login or Register  to view this content.

First question solved:

Please Login or Register  to view this content.

Second question is already working.

Thank you AB33