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
 
Top