How to call/display UserForm from others UserForm

[iqballud]

Hi Guys,

I have 4 UserForm, file attached please.
UserForm1: to call UserForm 2,3, and 4.
UserForm2: to call UserForm 1,3, and 4.
UserForm3: to call UserForm 1,2, and 4.
UserForm4: to call UserForm 1,2, and 3.
I used code: userform.Show and Me.Hide.
The problem is when i call UserForm2 from UserForm1, thats fine, but when i call UserForm3 from UserForm 2 that is shown UserForm1, not UserForm3 (i used code: Me.Hide).
Can anyone to solved the code, please?
Thanks in advanced.

Regards,
Iqbal

[6StringJazzer]

On UserForm2, you have a button called "Call Form 3." The code to implement that button simply says

Please Login or Register  to view this content.

So you display UserForm2, then click the button, then hide UserForm2. Remember, Me refers to the object containing the code. Hence back to UserForm1, which was patiently waiting for you to finish up whatever you were doing with UserForm2.

If you want UserForm2 to show UserForm3, then you need code that looks like this in UserForm2:

Please Login or Register  to view this content.

[iqballud]

Hi Jazzer,
Thanks a lot for your quick response.
I changed already as your advice, the code in UserForm2 (file attached), and Debug, because Form1 already shown when the commandbutton on sheet1 clicked. As I know we can't repeat the code to call userform from other user form if the UserForm already shown.

Regards,
Iqbal

[iqballud]

Guys, can we use case select statement to show/display multiple UserForm?

[Norie]

Why don't you unload instead or hide?

[iqballud]

Hi Norie,
I was changed by unload instead or hide, and same problem.
If only 2 UserForm, it will working properly by using this code: Userform(X).Show and UserForm(X).Hide or Unload UserForm(X).
But if the UserForm more than 2, then it's not working properly (by using: .Show and .Hide or Unload), e.g.: UserForm1: Shown --> then Call UserForm2 ---> then Call UserForm3 ----> If I want to Call UserForm1, the UserForm2 will be shown because the last call was UserForm2.
I am trying by code If..then..else..but again debug.

Regards,
Iqbal

[iqballud]

Hi Guys,
I have been tried to solve the problem, then finally i got it, please find the file (attached), but....still, another problem has come.
Below the code I wrote in Module:

Please Login or Register  to view this content.

And this code i wrote in CommandButton, just example to call UserForm1 from UserForm2, etc.,:

Please Login or Register  to view this content.

The problem is the UserForm will be displayed and staying continuously, i meant if i click 50 times from 4 UserForm, then 50 UserForm will be displayed. You can try by download the file.
Can anyone to solved this issue please?
I need 4 UserForm only will be displayed and enable to call/display from each others.

Regards,
Iqbal

[john55]

or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[iqballud]

John...thank you sooo...much, perfect and simple.
I'd like to give excellent reputation, but it could not be, there is dialogue "You must spread some Reputation around before giving it to john55 again".
Linkin Park...cool John, the first i heard the song "The Wall" rearrangement by this group.

Regards,
Iqbal

[iqballud]

John, I did to add reputation....again thank you John.

[john55]

You're welcome! glad I could help you! Thx for rep!
yeap, you gave me some rep 2 days ago for another thread (command button color...) and the system doesn't allow you to spread rep to the same user even if it's different thread (I am not agree with this precaution measure...but this is another problem!), you need to spread rep to someone else and then come back, thx again!

Linkin Park! ... last week-Simon & Garfunkel