Two userforms on one sheet

G

Guest

Guest
Is it possible to show two user forms at the same time on one sheet? (userform1 in the left corner and userform2 in the center)
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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.
 
Upvote 0
A way round this could be to use a multi-page or tab-strip and put the controls from each userform on separate tabs or pages, so the user can flick back and forth between them.
 
Upvote 0
If you are using excel2K + then you can show
both forms BUT as Gary has said only one
,the last one loaded will have focus.
The Key to showing both is to set the Modal property to False & obviously setting up the
forms position ie have the Startupposition set to Manual.


Ivan
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top