Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-18-2022, 07:41 PM
balavaka balavaka is offline need some change in this Windows 10 need some change in this Office 2013
Novice
need some change in this
 
Join Date: May 2021
Posts: 25
balavaka is on a distinguished road
Default need some change in this

I need to find and change only on paragraphs which tag contains like at start (e.g. <S1>, <S2>, <S3>)


Sub TitleCase()
Dim lclist As String
Dim wrd As Integer


Dim sTest As String

' list of lowercase words, surrounded by spaces
lclist = " of the by to this is from a and in with on for through are they via at an as "

Selection.Range.Case = wdTitleWord

For wrd = 2 To Selection.Range.Words.Count
sTest = Trim(Selection.Range.Words(wrd))
sTest = " " & LCase(sTest) & " "
If InStr(lclist, sTest) Then
Selection.Range.Words(wrd).Case = wdLowerCase
End If
Next wrd
End Sub
Attached Files
File Type: docx Before and After Change.docx (11.9 KB, 7 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Event to change cell in same row doesn't work if user clicks other row Peterson Excel Programming 4 05-10-2021 04:59 PM
Track changes problem: When I hover over a change, the bubble with change info. flashes rapidly Thankful Word 0 01-29-2021 09:04 AM
How to change and implement default theme font style change Nikko963 Word 5 05-04-2018 09:11 AM
Change computer's time, and all appointment times in Outlook's calendar change TimTDP Outlook 0 03-14-2017 06:56 AM
need some change in this change the view to final, my change bars disappear. I need them visible anna.a.julin Word 1 03-01-2012 08:05 PM

Other Forums: Access Forums

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