VBA to find and replace but ask to continue

		Microsoft Office Forums > Microsoft Word > Word VBA
VBA to find and replace but ask to continue

FAQ

Thread Tools

Display Modes

06-29-2022, 01:26 PM

gmaxey

Windows 10 VBA to find and replace but ask to continue

Office 2016

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,636

Jeffery,

A personal style thing. Not always needed.

Code:

Sub Demo()
Dim oRng As Range
  Set oRng = ActiveDocument.Range
  On Error GoTo Err_Handler
  Err.Raise 6
  MsgBox "You won't see this message"
lbl_Exit:
  Set oRng = Nothing
  Exit Sub
Err_Handler:
  MsgBox "An error has occurred"
  Resume lbl_Exit
End Sub

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you use the find and replace tool to find dates and times in Excel 2013?	Jules90	Excel	3	04-14-2020 07:40 PM
In Find and Replace, can Word stop after each Replace?	wardw	Word	1	06-08-2017 02:47 PM
Find what box in Find and replace limits the length of a search term	Hoxton118	Word VBA	7	06-10-2014 05:05 AM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
Help with find and replace or query and replace	shabbaranks	Excel	4	03-19-2011 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.