How to Use MultiPage Control on UserForm in Excel

MultiPage Control in Excel User Forms

Sometimes our Excel User Form will have many controls and relevant data entry points and may become difficult to work with. In order to make our work smoother we can divide the user-form into smaller user-forms called multi-pages. Transferring data from such multi-forms to an Excel worksheet is quite easy using VBA. To insert mult-pages into our user-from we click on the MultiPage icon in the controls tool box and then click and drag inside our standard user-form.

MultiPage User Form Excel
MultiPage User Form Excel

The complete VBA code for this form is given below:

Private Sub cmdCancel_Click()
Unload Me
End Sub

Private Sub cmdTransfer_Click()
Range(“A3”).Value = Me.TextBox1.Value
Range(“B3”).Value = Me.TextBox2.Value
Range(“C3”).Value = Me.TextBox3.Value
Range(“D3”).Value = Me.TextBox4.Value
Range(“E3”).Value = Me.TextBox5.Value
Range(“F3”).Value = Me.TextBox6.Value
Range(“G3”).Value = Me.TextBox7.Value
Range(“H3”).Value = Me.TextBox8.Value
Range(“I3”).Value = Val(Me.TextBox7.Value) * Val(Me.TextBox8.Value)
If Me.optDelivered.Value Then
Range(“J3”).Value = Me.optDelivered.Caption
End If

End Sub

Please note that the names for the OptionButtons.

Watch the Excel training video:

Further reading:
How to Use the MultiPage Control in a UserForm

Published by

Dinesh Kumar Takyar

Welcome to! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: For a structured Excel VBA training course online you can visit:

2 thoughts on “How to Use MultiPage Control on UserForm in Excel”

  1. dear sir ,
    thanks for teaching on line,
    dear sir i wont to make multipage control on userform in excel ,
    i saw your video but i can’t do same as your sheet, i don’t use vb data so i request to you plz teach me in deep or send me its .xls file.

    your thankful D.M.

    1. No cost online flash gaem0&#823s; With havin therefore considerably written content do you run into any concerns of plagorism or perhaps copyright infraction? My internet site has a lot of completely exclusive content I have either composed myself or perhaps outsourced nonetheless it looks like plenty of it is really popping it up most ov…

Leave a Reply

Your email address will not be published. Required fields are marked *