It depends on what you want to do.
You can bring up a second userform from an action from a userform that is already shown, but the last userform to be shown is the one that will hold the focus until it is hidden or unloaded.
Code like:
UserForm1.Show
UserForm2.Show
will show the first one and the second form won't show until the first form is closed or hidden.