Excel multiple userforms

[Apple08]

Hi All

I have two userforms, Userform1 and UserForm2, and I have commandButton1 and commandbutton 2 to open up these two userforms in the worksheet.

[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]Private Sub CommandButton1_Click()
 
'UserForm1.Show vbModeless

UserForm1.Show
 
End Sub
 
Private Sub CommandButton2_Click()


UserForm2.Show

 
End Sub[/COLOR][/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/CO[/COLOR][/SIZE][/FONT]DE]

However, only the commandbutton1 works to open the userform1 but when I click the commandbutton2 the userform2 doesn't show and there is no error message.  Please could anyone help me to resolve this?  Thanks.

 

[My Aswer Is This]

To open up Two Userforms you need to open them like this:
Now you must realize if they are both the same exact size they may be setting on top of each other.

Sub Show_Me()
'Modified  2/24/2020  12:03:17 PM  EST
UserForm1.Show Modeless
UserForm2.Show Modeless
End Sub

 

[Apple08]

Thanks. How about if I want user to open them separately, to close down another one before open up another one? Thanks.

 

[My Aswer Is This]

Not sure what you want exactly.
You want user to click one button to close one Userform1 and at the same time Open Userform2?

It would be something like this.

Unload Userform1
Userform1.show

 

[snjpverma]

To open up Two Userforms you need to open them like this:
Now you must realize if they are both the same exact size they may be setting on top of each other.

Sub Show_Me()
'Modified  2/24/2020  12:03:17 PM  EST
UserForm1.Show Modeless
UserForm2.Show Modeless
End Sub

What is modeless used for?

 

[My Aswer Is This]

What is modeless used for?

If you open your userform as modeless you can then click on your worksheet and do all you want with the userform displayed.

 

[Apple08]

Thank you! it works perfectly!
Please could you tell me where to see the properties of the cammandbutton so as to rename it? When I view the code, I can only see the properties of worksheet1 but commandbuttons are not there. Many thanks.

 

[My Aswer Is This]

Thank you! it works perfectly!
Please could you tell me where to see the properties of the cammandbutton so as to rename it? When I view the code, I can only see the properties of worksheet1 but commandbuttons are not there. Many thanks.

You need to click on the command button. Then look in properties window and you will see where to replace name. It's the first one in the properties window.

On another subject.
Why do you need two Userforms?
Have you ever looked at using a Userform Multipage control?
Look in the Userform Tool Box put one on your empty Userform and see how it works.
It's like have several Userforms all on the same Master Userform.

 

[Apple08]

Thank you! I do need two userforms and they both already have multiple pages on. They are for different purposes. Many thanks for your help. I appreciate it very much!

 

[My Aswer Is This]

Thank you! I do need two userforms and they both already have multiple pages on. They are for different purposes. Many thanks for your help. I appreciate it very much!

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.