I was looking for a macro on sequential Numbering and came across this code on one of the threads.
I would like to adapt this code by changing the input boxes to read from a userform text boxes, place it in a bookmark and also add the provision to print multiple copies of one document?
Thankyou.
Code:
Sub CertificatePrint()
Dim iStart As Integer, iEnd As Integer, i As Integer, StrArry
On Error GoTo ErrHandler
iStart = CInt(InputBox("What is the first Certificate to print?", "Print Certificates From", "1"))
iEnd = CInt(InputBox("What is the last Certificate to print?", "Print Certificates To", iStart))
If iStart = 0 Or iStart > iEnd Then Exit Sub
With ActiveDocument
For i = iStart To iEnd
With .Shapes(1).TextFrame.TextRange.Fields(1)
StrArry = Split(.Code.Text, " ")
.Code.Text = Replace(.Code.Text, StrArry(UBound(StrArry)), i)
.Update
End With
.PrintOut
Next
End With
ErrHandler:
End Sub