Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-25-2024, 10:40 AM
gmaxey gmaxey is offline VBA Find Bold Text within Brackets and Add Quotes Windows 10 VBA Find Bold Text within Brackets and Add Quotes Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

I think in this case you will need to find within a find:


Code:
Sub DPU_BoldTextWithinBrackets_AddQuotes2()
Dim oRng As Range
Dim oRng2 As Range
  Set oRng = ActiveDocument.Range
  Application.ScreenUpdating = False
  With oRng.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "\(*\)"
    .Wrap = wdFindStop
    .Format = True
    .MatchWildcards = True
    While .Execute
      Set oRng2 = oRng.Duplicate
      With oRng2.Find
        .Format = True
        .Font.Bold = True
        Do While .Execute
          If oRng2.InRange(oRng) Then
          If Not oRng2.Characters.First = Chr(34) Then
            oRng2.InsertBefore Chr(34)
            oRng2.Characters.First.Font.Bold = True
            oRng2.InsertAfter Chr(34)
            oRng2.Collapse wdCollapseEnd
          End If
        Else
          Exit Do
        End If
      Loop
      End With
      oRng.Collapse wdCollapseEnd
    Wend
  End With
  Application.ScreenUpdating = True
lbl_Exit:
  Exit Sub
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Last edited by gmaxey; 09-25-2024 at 12:50 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Find Bold Text within Brackets and Add Quotes VBA Find Bold Text within Brackets and Add Quotes Shelley Lou Word VBA 6 07-12-2024 08:43 AM
VBA Find Bold Text within Brackets and Add Quotes VBA format plain quotes to bold quotes Shelley Lou Word VBA 3 02-11-2024 05:56 AM
Subscript and bold number between square brackets and remove square brackets nonno Word 0 02-10-2024 08:23 AM
Find and delet all text within brackets and the brackets themselves ranjan Word VBA 2 07-22-2021 01:06 AM
VBA Find Bold Text within Brackets and Add Quotes find and delet all text within brackets and the brackets themselves wrdy Word 2 08-03-2017 06:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:23 AM.


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