Userform opening, running order in VBA

[selant]

I am working in VBA environment i have 2 forms in the project, when I press F5 to run the scripts, userform2 opens. I want to open userform1 when pressing F5. How to change the order ?

 

[RolfJ]

When you press F5 VBA always starts with the code that is on top. Try this out: set your VBA to view UserForm1. Now F5 will cause that form to show up first. The way to control which user form shows up first is to create a macro routine in a standard VBA module which then explicitly shows a specific form, e.g.

Sub Test()
    UserForm1.Show
End Sub

Hope this helped,
Rolf

 

[selant]

Thank you.