PDA

View Full Version : Solved: Switching between Userforms



chocho
01-13-2013, 09:41 PM
So this should be easy but I keep running into problems:
See attached file for the problem, but in summary:
I have a main userform and a second userform. Command button on userform 1 takes you to userform 2 and hides userform 1. I want the exit button on userform 2 to hide it and take you back to userform 1. However when you cycle through a couple times it gets frozen at userform 2.

I should also mention that I would not like to change the modality of the userforms, and if I must I will change it of userform 1.

Jan Karel Pieterse
01-14-2013, 01:08 AM
Perhaps like so...

snb
01-14-2013, 03:38 AM
see the attachment

Jan Karel Pieterse
01-14-2013, 05:20 AM
snb: that is a useful alternative.
I sometimes use two frames instead of the multipage because for frames you can change the background color.

snb
01-14-2013, 05:49 AM
@JKP
That's right, I prefer colouring the background of a multipage page too.
For that purpose I 'cover' each page with a frame which's background colour can be adapted. Of course too much controls to create this, but the only way I know of to overcome the missing background property of a page in a mulitpage.

The attachment in 'full' colour

chocho
01-14-2013, 06:32 AM
Thanks for your help guys!