At once Print Reports with different information AUTOMATICALLY.

Hi All!

I am working in a college and I have to print many sheets daily in excel.
But every time I print single sheet at once and then next and then next. All this manually.
And every page has the information of single student.


So I make a sample worksheet and need a macro

I Need
When I open user form and
Type in Textbox1 = 2
Type in Textbox1 = 8
Then press command button

It should print this page with roll number 2 to 8
It should put 2 in Yellow box, update the data and print
Then auto put 3 in yellow box and update the data and print
Till 8 number it should print all the cards.

Can anyone help me in this.

I shall be very thankful to you.

Try this:

Private Sub CommandButton1_Click()
    Dim l As Long
    On Error GoTo Terminate
    For l = TextBox1.Value To TextBox2.Value Step Sgn(TextBox2.Value - TextBox1.Value)
        With Sheet2
            .Range("B3").Value = l
            .PrintOut
        End With
    Next l
Terminate:
    If Err.Number Then
        MsgBox "An error occured", vbExclamation + vbOKOnly, "Excel Forum"
        Err.Clear
    End If
End Sub