Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you can achieve your needs using another aproach, you can use regular expressions: