Highlight words from a list

Nanaia · #1 09-05-2018, 04:56 PM

I'm trying to create a macro so that when it's applied it will highlight specific words from a list of words I have. I've got the macro started however I can't seem to figure out how to keep it from highlighting words within words. For example, I want it to highlight the word in, which it will do, but it also highlights it in the word involved and being. Any help, or recommendation for an alternate macro is appreciated. I know I ran across something like this once before but am having difficulty relocating it. This is what I have so far:

Code:

Sub ListChange()
Dim r As Range
Dim MyList() As String
Dim i As Long
MyList = Split("additionally,ah,almost,big,can be,could,could be,generally speaking,he,in,it,it is,low,many,may,might,most,plenty,she,should,some,these,they,this is,we,with", ",")
For i = 0 To UBound(MyList())
   Set r = ActiveDocument.Range
      With r.Find
         .Text = MyList(i)
         .Replacement.Highlight = wdYellow
         .Execute Replace:=wdReplaceAll
         .MatchWildcards = False
         .MatchWholeWord = True
         .MatchAllWordForms = False
      End With
Next
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find (highlight) two and more words in a list of 75k single words in Word 2010	Usora	Word	8	05-29-2018 03:34 AM
Macro to highlight a list of words	bakerkr	Word VBA	4	10-19-2017 02:23 PM
Highlight Words from a Word List	JSC6	Word VBA	1	09-30-2014 08:22 PM
Using macros to highlight worksheet words referenced in external list/doc.	Daniel_NYC	Word VBA	1	04-21-2014 03:35 PM
VBA to highlight words if used too much	aolszewski	Word VBA	3	11-23-2013 02:07 AM