Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-16-2023, 01:32 PM
vivka vivka is offline A Makro for automatically insert captions for specific letters Windows 7 64bit A Makro for automatically insert captions for specific letters Office 2016
Expert
 
Join Date: Jul 2023
Posts: 302
vivka is on a distinguished road
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
A Makro for automatically insert captions for specific letters VBA to insert captions without appending to existing captions Marrick13 Word VBA 17 03-21-2023 07:51 PM
A Makro for automatically insert captions for specific letters Insert Captions and Word Wrap TEAllred Word 1 11-22-2015 03:21 PM
A Makro for automatically insert captions for specific letters Captions: Changing captions in Appendix update all captions carnestw Word 3 10-27-2015 12:34 PM
A Makro for automatically insert captions for specific letters Captions automatically updating all previous entries jhats Word 1 07-29-2014 11:53 PM
A Makro for automatically insert captions for specific letters Captions mixing letters and numbers trew Word 7 11-21-2012 12:54 AM

Other Forums: Access Forums

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