Uploaded April 2020 | Updated November 2026, 12 hours ago
How To find and replace multiple words at the same time in a Word document using VBA.
Here's the complete VBA code.:
NOTE: Please replace 'Not Equal to' with angular brackets as shown in the video.
Option Explicit
Sub FindAndReplaceMultipleWordsInDocument()
Dim strFind As String, strReplace As String
Dim strFindArr, strReplaceArr
Dim i As Long
Application.ScreenUpdating = False
strFind = InputBox("Enter words to find separated by a comma ", "Enter words to find")
strReplace = InputBox("Enter the new replacement words separated by a comma.", "Enter Replacing Words")
strFindArr = Split(strFind, ",")
strReplaceArr = Split(strReplace, ",")
If UBound(strFindArr) 'Not Equal To' UBound(strReplaceArr) Then
MsgBox "find and Replace words must be equal.", vbInformation, "Find Replace"
Exit Sub
End If
For i = 0 To UBound(strFindArr)
Selection.HomeKey Unit:=wdStory, Extend:=wdMove
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = strFindArr(i)
.Replacement.Text = strReplaceArr(i)
.MatchWholeWord = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
Next
Application.ScreenUpdating = True
End Sub
Details also available at exceltrainingvideos.com/find-and-replace-multiple-words-in-word-document
How To find and replace multiple words at the same time in a Word document using VBA.
Here's the complete VBA code.:
NOTE: Please replace 'Not Equal to' with angular brackets as shown in the video.
Option Explicit
Sub FindAndReplaceMultipleWordsInDocument()
Dim strFind As String, strReplace As String
Dim strFindArr, strReplaceArr
Dim i As Long
Application.ScreenUpdating = False
strFind = InputBox("Enter words to find separated by a comma ", "Enter words to find")
strReplace = InputBox("Enter the new replacement words separated by a comma.", "Enter Replacing Words")
strFindArr = Split(strFind, ",")
strReplaceArr = Split(strReplace, ",")
If UBound(strFindArr) 'Not Equal To' UBound(strReplaceArr) Then
MsgBox "find and Replace words must be equal.", vbInformation, "Find Replace"
Exit Sub
End If
For i = 0 To UBound(strFindArr)
Selection.HomeKey Unit:=wdStory, Extend:=wdMove
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = strFindArr(i)
.Replacement.Text = strReplaceArr(i)
.MatchWholeWord = True
End With
Selection.Find.Execute Replace:=wdReplaceAll
Next
Application.ScreenUpdating = True
End Sub
Details also available at exceltrainingvideos.com/find-and-replace-multiple-words-in-word-document










