opening a userform from a userform

[Roger on Excel]

Is there a way to open and use a userform from another userform?

I am using userforms for data entry and would like the option to open a
second form whilst entering data into a form

Can anyone help?

[excel 2003]

 

[Rick Rothstein]

Just Show it. Call is like this...

UserForm2.Show

or like this...

UserForm2.Show vbModeless

depending on whether you want UserForm2 to be modal or non-modal. Remember
to change my example UserForm name from UserForm2 to whatever the name your
second UserForm is.

 

[Ryan H]

Yes you can. Put a button on your userform you are entering data and call
your secondary userform in the commandbutton_Click event. For example,

Private Sub CommandButton1_Click()
UserForm1.Show
End Sub

Make sure your secondary userform has the property ShowModel set to False,
so you will still beable to enter data into your orginal userform.

Hope this helps! If so, click "YES" below.