pass comboboxvalue to another userform

[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

 

[Nick Hodge]

Jan

This could be passed as a public variable to another module prior to
unloading the form. (Unloading the form removes it from memory including
any objects values.

Alternatively, you could simply 'Hide' the form (UserformName.Hide). This
way you can still 'read' the value of the objects on it.

Another way would be to use a hidden sheet in the workbook to hold values.
If you use

NameOfWorksheet.Visible=xlSheetVeryHidden

The sheet will not be listed to the user as hidden and will only be able to
be shown again through code.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)