Hello all, pretty new into VBA and still learning a lot. I've been trying to figure out how to create a macros that references an external list of words (word,excel,.txt) and only uses it/the words as a reference to highlight those specific words in the any word excel sheet I would be using.



Example: One of my sheets contain 100s of ratios but I only want to focus on some select few. I am aware of conditional formatting but want to figure out if macros is a possibility to aid our department. So the whole thing would be to use an external list (document/sheet always in the same file path), link it to the macros ran on the "ratios" excel sheet to simply highlight the "words" specified in such external list, and focus on solely those highlighted ratios.

I am a big newbie but trying! Any help would be greatly appreciated!!! Again, super new to this and a little lost!

There are numerous threads here discussing the use of Excel workbooks for Find/Replace data and for using Find/Replace to highlight text. For example, the following show how to use an Excel workbook for Find/Replace:
https://www.msofficeforums.com/word-...html#post34254
https://www.msofficeforums.com/word-...html#post61860
https://www.msofficeforums.com/word-...support-3.html
The following show a number of ways you might go about the highlighting:
https://www.msofficeforums.com/word-...html#post53881
https://www.msofficeforums.com/word-...per-nouns.html
https://www.msofficeforums.com/word/...html#post34984
This one even does both:
https://www.msofficeforums.com/word-...e-ms-word.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]