April 17, 2014

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

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…

Comments are closed.