Two userforms on one sheet

Mar 2nd, 2002, 11:45 AM

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)

gplhl · Mar 2nd, 2002, 01:23 PM

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.

Mudface · Mar 2nd, 2002, 01:38 PM

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.

Ivan F Moala · Mar 2nd, 2002, 01:39 PM

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

Mar 2nd, 2002, 01:23 PM	#2
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	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. __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 11:45 AM	#1
Guest Posts: n/a	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)

Mar 2nd, 2002, 01:38 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.

Mar 2nd, 2002, 01:39 PM	#4
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	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