Search/Find for multiple words stored in an array for a worksheet

**freshie1001** · 05-19-2016, 03:43 AM

Hello Folks

As mentioned above in the title, i would like to search for multiple words in my entire worksheet. Some of the words are Apple, Orange, Pear, as these words will change or get updated periodically, it would be good to store them in an Array.

I am not very good at programming, hope you guys could bear with me.

Much Appreciate!

Thanks

**Doc.AElstein** · 05-24-2016, 06:00 AM

Originally Posted by freshie1001

......i would like to search for multiple words in my entire worksheet. Some of the words are Apple, Orange, Pear, as these words will change or get updated periodically, it would be good to store them in an Array.
......

Hi freshie1001,
Welcome to the board

This sounds like something that there are infinite ways of doing with VBA.

You need to give us some more detail and some test data to work on.
Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
Show us clearly what you have and the results you want to achieve.
Please do not use images as we cannot copy them to a worksheet.
Instead:
Either
use the Add-In Linked in my signature or similar tools to produce screenshots that we can copy.
http://www.excelforum.com/the-water-...ml#post4354756
http://www.excelforum.com/suggestion...d-data-17.html
http://www.excelforum.com/showthread...t=#post4354867
http://www.excelfox.com/forum/showth...=9804#post9804
http://www.mrexcel.com/forum/about-b...rder-help.html
http://www.mrexcel.com/forum/about-b...nstalling.html
http://www.forumexcel.it/forum/16-te...ce-bb#post1576

Collection of codes here: After selecting a Spreadsheet range run the main code in any of the modules:
https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9

Basically to use those tools you highlight the part of your Spreadsheet of interest, and then run the code which copies that screenshot in a BB Code Tag type format into your Clipboard. You then paste that into the Post Editor window. When posted it comes out in a formatted table. Practice using those tools in our Test Sub Forum. To do that start a “test” thread here and practice!!!
http://www.excelforum.com/development-testing-forum/

_....
or
Upload a File
http://www.excelforum.com/the-water-...his-forum.html
http://www.excelforum.com/tips-and-t...le-upload.html
http://www.excelforum.com/excel-prog...ml#post3927818

Alan

P.s. Please read the Forum Posting guidelines, it is worth it in the long run! , thanks.

http://www.excelforum.com/forum-rule...rum-rules.html
Alan