How to show a second userform in front of the first one shown.

[OaklandJim]

I have a somewhat basic UserForm that includes a button that shows a second UserForm. All works well except that the second userform is shown behind the first one when it starts up. How do I tell the second one to be in front to the first one?

 

[Micron]

If the 1st one is modal, I don't think you can. So set ShowModal property of 1st form to no, or in vba, open it that way. For second form, it depends on what you want to do after.

 

[6StringJazzer]

I set up a test like the one you described and I cannot reproduce your results. In my test the second form is on top and has focus.

I have tested all combinations of modal and modeless forms, and calling from standard modules and from within the forms. For all the valid* ones, the second form to be shown is on top and has focus. (*You cannot Show a modal form from a modeless form.)

Can you give us more detail about your setup? If you want I can link to a test file for what I tried.

 

[Keebellah]

Sample file would help too

 

[Micron]

It's probably better to hide the first form instead of trying to control its z order?
EDIT - if both of my forms have ShowModal set to no the following works, but not if the 1st is set to true

UserForm.Show vbModeless
UserForm3.Show vbModal