Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2023, 02:50 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

It is even simpler:
Code:
Sub Repl_Stri_W_Sequential_Nums()
'In slection, replace all instances of the inputboxed string
'with captions.

Dim myRng As range
Dim stri As String

Application.ScreenUpdating = False

Set myRng = selection.range
    stri = InputBox("Enter the string to find")
    With myRng.Find
        .ClearFormatting
        .Replacement.ClearFormatting
        .text = "Figure " & stri
        .Forward = True
        .Wrap = wdFindStop
        Do
            If .Execute And myRng.InRange(selection.range) Then
                myRng.Delete
                myRng.InsertCaption label:="Figure", _
                    TitleAutoText:="", _
                    Title:="", _
                    Position:=wdCaptionPositionBelow, _
                    ExcludeLabel:=0
            Else: Exit Do
            End If
            myRng.Collapse wdCollapseEnd
        Loop
    End With
Application.ScreenUpdating = True
Set myRng = Nothing
End Sub

Reply With Quote
Reply



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 03:34 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