VBA Find and Replace

Home Up Odds & Ends Photo Gallery Search Contact Me Privacy Notice

 

 

The information in this website is provided without risk or obligation and free of charge.  However, if you have benefitted from my efforts here and would like to make a contribution to help me continue and maintain this work then any donation will be greatly appreciated. Please click the adjacent button to access PayPal.  Thank you.
 

The purpose of this Microsoft Word Help & Tips Page is to provide "VBA Find and Replace" to the Word user community.  VBA Find and Replace is intended as a manually loaded Word Add-In.  It provides a VBA method for finding and replacing text anywhere in a document.  It incorporates methods for processing a batch of files located in a common directory, processing single words/phrases or a list of multiple find and replace words or phrases that are either pre-defined or created on the fly, and for replacing text with AutoText entries.  While I am the one that created the template, it would not have been possible without the help, mentoring and support of fellow MVPs Doug Robbins, Jonathan West, Steve Hudson, Graham Mayor; and regular newsgroup contributors Dave Lett and Jezebel.  A special thanks goes to MVP and good friend Graham Mayor for helping me find and fix the bugs.

The Add-In adds "VBA Find and Replace" command to the Edit menu (pre-Word 2007 versions) which calls a userform to provide the user interface.  The userform is shown below:

The "Info/Tips" command button on the userform opens a second userform containing information for using the Add-in. 

Download the template here:  VBA Find and Replace.    Then unzip the file to your Word Templates directory and load it using Tools>Templates and Add-Ins.  For more on Add-Ins and how to load them, see the heading "Organizing Global Templates" at:    Organizing Your Macros


Looking for something else?

Google