The Word MVP Site

• Word Home
• Word:mac
• Troubleshoot
• Tutorials
• Find Help
• About Us
• Contact
• Sitemap

• Word on the PC
  • Application errors
  • Customization
  • Drawing/Graphics
  • Formatting
  • General
  • Microsoft Word MVP FAQ
  • Macros/VBA
  • Mail merge
  • Numbering
  • Cross-Application dev.
  • Tables, Fields & Forms
  • Userforms
  • Tutorials

• Word on the Macintosh
  • Troubleshooting
  • Customization

Clear settings from Find and Replace dialog to prevent unexpected results from future Find or Replace operations

Article contributed by Bill Coan

To prevent the user from having to change the settings in the Find and Replace dialog after running your macros, make sure you call the following procedure after doing any Find and Replace operations in VBA.

Sub ClearFindAndReplaceParameters()

With Selection.Find
   .ClearFormatting
   .Replacement.ClearFormatting
   .Text = ""
   .Replacement.Text = ""
   .Forward = True
   .Wrap = wdFindStop
   .Format = False
   .MatchCase = False
   .MatchWholeWord = False
   .MatchWildcards = False
   .MatchSoundsLike = False
   .MatchAllWordForms = False
End With

End Sub