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?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!