Customize search with macro

[#1]

Dear community,

I would like to customize search feature so that it can search in Boolean format.

For example:

Client enter word - "Cat and fish or mouse",

it will search for the content with "Cat fish" or "Cat mouse" or "Car fish mouse", instead of "Cat" or "fish" or "mouse"...

Apparently default Search button cannot fix my requirement. so we came out with this idea:

1. Create an input box, so that client can key in their desired word to search

2. Create a button to run macro

3. Create a table to populate the data of searching

Do you think this is working or any other suggestion?

Anyone can help in the macro?

Thanks and best regards,

Chanel

[Andrea_Ghirardello]

If you can achieve your needs using another aproach, you can use regular expressions:

How to use regular expressions