Opening one userform on the right side of userform1

[Nancy123]

Hi All

I have designed a userform which has a number of commandbuttons. When we click on a commandbutton then the corresponding userform appears. Is it possible to open a new userform suppose userform2 on the right hand side of userform1. That means when the user clicks on any commandbutton in userform1 then instead of opening userform2 upon userform1, the userform2 should appear on the right empty side of userform1.

Can anyone please tell me how to do it? Do I need to use multipage? If yes can anyone please tell me how as I never used multipage in Excel.

Thanks

[Chippy]

Try playing around with the userform's Left and Width properties:

Please Login or Register  to view this content.

[Nancy123]

Thanks for your reply. But I don't want this thing . Is there any concept of subforms or multipage that could be benificial..

Thanks

[romperstomper]

Yes, there's a multipage, but that won't do what you actually asked for, whereas Chippy's suggestion will.