View Single Post
 
Old 04-19-2022, 12:43 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Try this
Code:
Sub ArrowMaker()
  Dim aRng As Range
  Set aRng = Selection.Range
  With aRng.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "p"
    .Replacement.Text = Chr(112)
    .Replacement.Font.Name = "Wingdings 3"
    .Replacement.Font.ColorIndex = wdRed
    .Forward = True
    .Wrap = wdFindStop
    .Format = True
    .MatchCase = True
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    .Execute Replace:=wdReplaceAll

    .Text = "q"
    .Replacement.Text = Chr(113)
    .Replacement.Font.Name = "Wingdings 3"
    .Replacement.Font.ColorIndex = wdGreen
    .Execute Replace:=wdReplaceAll
  End With
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote