comboboxes gove value to next userform

F

fa023678

Hi,

can get this ting right. Maybe you know how to?

In a userform is a combobox which value I want to keep using in a second
userform for a combobox over there.
Goal:
choose value in userform1 / combobox1 let say 4
unload userform1
show userform 2 with combobox2 filled with the chosen valu in this case 4

Do you kow how to achieve this?

Thanks,
jan
 
M

Martin Seelhofer

In a userform is a combobox which value I want to keep using in a second
userform for a combobox over there.
Goal:
choose value in userform1 / combobox1 let say 4
unload userform1
show userform 2 with combobox2 filled with the chosen valu in this case 4
Click to expand...

Why not keeping the first userform open by just hiding (Me.Hide)
instead of unloading (Unload Me)? You can always unload the
first userform when unloading the second one (Unload userform1)...


Cheers,

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Textbox input goes to 2 sheets in same wbk 0
pass comboboxvalue to another userform 1
Userform in Excel is blank 1
Making multiple ComboBoxes mandatory 5
Case Statement - Error handling 1
Use match function to add different item in Combobox 2
Userform to query? 3
use ComboBox value to select range and then use selected range tocreate a chart 3

Top