![]() |
|
#4
|
|||
|
|||
|
Hi, Lydia90! The code is simple and it does what you want. I added an inputbox in case you want to find sth else. Selection allows working on any selected range incl. the active document (Ctrl+A)
Code:
Sub Uppercase_Stri()
'In slection, find all instances of the inputboxed string
'and capitalize all their letters.
Dim myRng As range
Dim stri As String
Set myRng = selection.range
stri = InputBox("Enter the string to find")
With myRng.Find
.ClearFormatting
.Replacement.ClearFormatting
.text = stri
.Replacement.Font.AllCaps = True
.Forward = True
.Format = True
.MatchCase = True
.MatchWholeWord = True
.MatchSoundsLike = False
.MatchAllWordForms = False
.MatchWildcards = False
.Wrap = wdFindStop
.Execute Replace:=wdReplaceAll
End With
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
VBA to insert captions without appending to existing captions
|
Marrick13 | Word VBA | 17 | 03-21-2023 07:51 PM |
Insert Captions and Word Wrap
|
TEAllred | Word | 1 | 11-22-2015 03:21 PM |
Captions: Changing captions in Appendix update all captions
|
carnestw | Word | 3 | 10-27-2015 12:34 PM |
Captions automatically updating all previous entries
|
jhats | Word | 1 | 07-29-2014 11:53 PM |
Captions mixing letters and numbers
|
trew | Word | 7 | 11-21-2012 12:54 AM |