VBA to Replace Text in Multiple Text Boxes

JasonLZH · #1 05-18-2022, 11:23 PM

Hi, guys. I'm new to Word VBA and I would like to ask some questions here.

Let's say my word file has a few words named "[Name1]" and these words are located in multiple text boxes in a word file. Then, I want to change [Name1] to a person's name, and that's all.

I can replace these words if I do it manually, but it failed when I tried to use the following VBA codes:

Code:

Sub Macro2_Backup()

    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = "[Name1]"
        .Replacement.Text = "Mike"
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchByte = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
    
End Sub

I tried to find some ideas online but none of them clearly solved my doubts. Therefore, I would like to ask if there is someone who can show me a simple VBA code to replace words across multiple text boxes in a Word File.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA to find text, replace with multiple lines of text	noslenwerd	Word VBA	3	12-31-2019 11:04 AM
Select all text in multiple text boxes	Virgule	Word	0	06-07-2017 12:11 PM
Word 2013 Text boxes on everything, can't select across multiple boxes	1Kurgan1	Word	2	10-31-2016 01:20 AM
Drawing lines between text boxes which have actual text within the text boxes	RHODIUM	Word	6	10-01-2016 04:43 PM
Link text of multiple text boxes to one	witchcraftz	PowerPoint	0	08-28-2014 10:29 AM