![]() |
|
#11
|
|||
|
|||
|
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
|
|
|
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 |