Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 10-18-2023, 10:36 AM
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

Lydia90, the following macro replaces all "Figure (your inputboxed txt)" with "Figure (sequential number)" and makes them captions in the selected range.
Code:
Sub Repl_Stri_W_Sequential_Nums()
'In slection, replace all instances of the inputboxed string
'with sequential numbers / add sequential numbers after each
'instance of the inputboxed string.

Dim myRng As range
Dim stri As String
Dim i As String

Application.ScreenUpdating = False

Set myRng = selection.range
    stri = InputBox("Enter the string to find")
    i = InputBox("Enter the number to start counting from")
    With myRng.Find
        .ClearFormatting
        .Replacement.ClearFormatting
        .text = "Figure " & stri
        .Forward = True
        .Wrap = wdFindStop
        Do
            If .Execute And myRng.InRange(selection.range) Then
                i = i + 1
                myRng = "Figure " & i
                myRng.Style = wdStyleCaption
            Else: Exit Do
            End If
            myRng.Collapse wdCollapseEnd
        Loop
    End With
Application.ScreenUpdating = True
Set myRng = Nothing
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 06:17 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