Going from userform1 to userform2 and then back to userform1

[MFish]

I have a combobox1 in UF1 that is coded as...

sub combobox1_change()
[INDENT]
userform2.show
[/INDENT]

end sub

Once userform2 shows up, I need another combobox to select something.

Code I have...

Sub combobox1()
[INDENT]
Me.combobox1.List = Worksheets("Drop Down Data").Range("d3:d51").Value
[/INDENT]

end sub

Once selected I press submit, on a commandbutton1, and after pressing submit it will transfer that data, I just selected within userform2 in combobox, to textbox1 in userform1.

But when I try to use code...

sub commandbutton1_click()

[INDENT]userform1.show
[/INDENT]

end sub

It says it won't be able to perform because that userform is already opened.. How do I get the userform to show again and taking the value of that combobox in userform2 into a textbox in userform1?

 

[Steve_]

If you did not hide it, then it is already "displayed". you probably should do a userform2.hide to get back to userform1.

 

[DanteAmor]

Try this:

Userform1:

Private Sub ComboBox1_Change()
    UserForm1.Hide
    UserForm2.Show
End Sub

Userform2:

Private Sub CommandButton1_Click()
    UserForm1.TextBox1.Value = Me.ComboBox1.Value
    UserForm1.Show
    Unload Me
End Sub

-----------
Or Change the ShowModal property of both userforms to False In the properties of the userform.