Hi, this is probably a stupid question, but does it matter if the dependent (combobox) drop down menus for a userform are on the same page? Like, can I have one on one of the tabs for a multipage form and one on another? or will that cause an issue?
Hi, this is probably a stupid question, but does it matter if the dependent (combobox) drop down menus for a userform are on the same page? Like, can I have one on one of the tabs for a multipage form and one on another? or will that cause an issue?
It doesn't matter where you get the data from which are loaded into a ComboBox. Once they are loaded, usually when the userform is activated (and it doesn't matter which method of loading you choose), there is no further connection between the Cbx and the data source.
Quite on the contrary, I would keep the lists for my Cbxs on a dedicated sheet, Very Hidden from the user.