Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-24-2015, 02:43 AM
jc491's Avatar
jc491 jc491 is offline VBA Word  - Find & Apply Styles to Specific Words - Using Case Statement Windows 10 VBA Word  - Find & Apply Styles to Specific Words - Using Case Statement Office 2016
VBA Novice
VBA Word  - Find & Apply Styles to Specific Words - Using Case Statement
 
Join Date: Sep 2015
Location: UK
Posts: 55
jc491 is on a distinguished road
Default


Hello Paul,

thank you so much for helping me again for the zillionth time

I run the code and here is what I get




Code:
Sub PaulDemo()
Application.ScreenUpdating = False

Dim StrSty As String, StrRep As String, i As Long

StrSty = " Strong, Heading 1"

StrRep = "Placeholder1 ^& Placeholder2,Heading 1 ^& Heading2"

With ActiveDocument.Range.Find
  .ClearFormatting
  .Replacement.ClearFormatting
  .Forward = True
  .Format = True
  .Wrap = wdFindContinue
  .MatchWildcards = True
  For i = 0 To UBound(Split(StrSty, ","))
    .Style = Split(StrSty, ",")(i)
    .Replacement.Text = Split(StrRep, ",")(i)
    .Execute Replace:=wdReplaceAll
  Next
End With
Application.ScreenUpdating = True
End Sub
The placeholders should be around each word as they show in the code, sorry for being a pain, have I not run it properly again.


forever grateful

J
Reply With Quote
Reply

Tags
apply style, case



Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply styles in word table 1van Word VBA 2 11-17-2015 11:05 AM
VBA Word  - Find & Apply Styles to Specific Words - Using Case Statement VBA Word - Format ALL Tables - Apply Specific Formatting to Sets of Columns – Font, Border & Width jc491 Word VBA 10 11-04-2015 04:02 PM
Question about Case statement Jennifer Murphy Word VBA 1 01-05-2013 02:30 PM
Paragraph space before - can styles apply it intelligently? timpani Word 7 10-23-2012 04:08 PM
FInd recurring words in Word 2003 NJ007 Word 4 01-25-2010 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:00 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