Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-17-2021, 04:25 PM
Guessed's Avatar
Guessed Guessed is offline Move Selection to First of Two Search Candidates Windows 10 Move Selection to First of Two Search Candidates Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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

There may be a more elegant way to do this but this is my initial thoughts on how to solve it
Code:
Sub ChickenOrEgg()
  Dim aRng As Range, rngHigh As Range, rngTurq As Range  
  Set aRng = Selection.Range
  aRng.End = ActiveDocument.Range.End
  With aRng.Find
    .ClearFormatting
    .Highlight = True
    .Text = ""
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = True
    .MatchCase = False
    If .Execute Then Set rngHigh = aRng.Duplicate
  End With
  
  Set aRng = Selection.Range
  aRng.End = ActiveDocument.Range.End
  With aRng.Find
    .ClearFormatting
    .Font.ColorIndex = wdTurquoise
    .Text = ""
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = True
    .MatchCase = False
    If .Execute Then Set rngTurq = aRng.Duplicate
  End With
  
  If rngHigh Is Nothing Then
    If rngTurq Is Nothing Then
      MsgBox "No hits for either"
    Else
      rngTurq.Select
    End If
  Else
    If rngTurq Is Nothing Then
      rngHigh.Select
    Else
      If rngHigh.Start < rngTurq.Start Then
        rngHigh.Select
      Else
        rngTurq.Select
      End If
    End If
  End If
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Dragging a selection to copy it, not to move it wardw Word VBA 2 11-28-2019 11:09 AM
Move Selection to First of Two Search Candidates How to move a selection one cell up using VBA? Bumba Excel Programming 6 11-19-2019 08:50 AM
Move Selection to First of Two Search Candidates Move Selection to the next Column on a Page (Not a table) GuitarForLife Word VBA 7 02-09-2018 01:59 PM
Search a folder to move an email to koolman31 Outlook 0 02-11-2016 10:29 AM
Move Selection to First of Two Search Candidates Search and reduce the range of a text selection paik1002 Word VBA 1 12-17-2015 04:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft