How to find and replace specific text in text boxes in Excel?

The Find and Replace tool is an essential feature for quickly updating cell contents or formulas within a worksheet. However, managing text within multiple text boxes can be a challenge if you're limited to manual updates. If you need to find specific text in text boxes and replace it efficiently, this tutorial will guide you through using VBA code to handle this task in just a few steps.

Find and replace specific text in multiple text boxes

Find and replace specific text in multiple text boxes

You can manually find and replace text one by one, but this process becomes tedious and time-consuming when dealing with multiple text boxes. The following VBA code provides an efficient way to complete this task all at once.

1. Activate your worksheet, and hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Find and replace specific text in text boxes of current worksheet

Sub TextBoxReplace()
'Updateby20140603
Dim xWs As Worksheet
Dim shp As Shape
Dim xFindStr As String
Dim xReplace As String
xFindStr = Application.InputBox("Find:", xTitleId, "", Type:=2)
xReplace = Application.InputBox("Replace with:", xTitleId, "", Type:=2)
Set xWs = Application.ActiveSheet
On Error Resume Next
For Each shp In xWs.Shapes
    xValue = shp.TextFrame.Characters.Text
    shp.TextFrame.Characters.Text = VBA.Replace(xValue, xFindStr, xReplace, 1)
Next
End Sub

3. Then press F5 key to run this code, and a prompt box will pop out to remind you entering your old text that you want to replace. See screenshot:

4. Go on clicking OK, and in this  prompt box, type the new text value that you want, see screenshot:

5. And then click OK button, the old values have been replaced with the new values that you entered in the current worksheet. See screenshots:

Related articles:

How to find and replace text in chart titles in Excel?

How to find and replace text within comments in Excel?

How to change multiple hyperlink paths at once in Excel?