![]() |
#1
|
|||
|
|||
![]()
Hello
With the help of some AI bots, the Word macro below was generated to use regex in Find and Replace with a YesNoCancel prompt (macro runs from cursor position). The problem with this macro is that when the Find string and Replace string are not of the same length, the first replacing is done correctly, but then the other search results are incorrectly selected, and no replacing is showing. AI bots are suggesting updating cursor position, but all their solutions don't work! Any help is much appreciated. PS: The pattern and replacementtext in the macro below are just examples. I need the macro for cases that are not supported by wildcards. Here's the macro: Code:
Sub PromptRegExReplace() Dim regEx As Object Dim match As Object Dim matches As Object Dim rng As Range Dim response As Integer Dim replacementText As String Set regEx = CreateObject("VBScript.RegExp") regEx.Pattern = "([0-9])" regEx.Global = True ' Get the current cursor position Dim cursorPosition As Long cursorPosition = Selection.Start ' Set the range to start from the cursor position until the end of the document Set matches = regEx.Execute(ActiveDocument.Range(cursorPosition, ActiveDocument.Range.End).text) replacementText = "$1abc" For Each match In matches Set rng = ActiveDocument.Range(match.FirstIndex + cursorPosition, match.FirstIndex + match.Length + cursorPosition) rng.Select response = MsgBox("Replace this instance?", vbYesNoCancel) If response = vbYes Then Application.ScreenUpdating = False rng.text = regEx.replace(rng.text, replacementText) Application.ScreenUpdating = True ElseIf response = vbCancel Then Exit Sub End If Next match End Sub |
Tags |
prompt, regex, replacing |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to keep a list of search results | Jedothek | Word | 2 | 08-19-2020 07:22 AM |
2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |
![]() |
alexb123 | Outlook | 1 | 10-10-2013 09:53 AM |
Search results disappearing | Emerogork | Office | 3 | 07-17-2011 03:52 PM |
Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |