Hello All,
I have been working on creating cascading drop down/combo boxes in a userform.
the user selects a "Zone" then a "Style" then selects a "Model"
I have a macro that creates a unique list of 'styles' based on the zone selected, and then a separate macro to create a unique list of 'Models" based on the 'Style selected'. these macros work great when i run them from a module, but when I try to run them from the userform combo box change event i get errors.
I have been working on creating cascading drop down/combo boxes in a userform.
the user selects a "Zone" then a "Style" then selects a "Model"
I have a macro that creates a unique list of 'styles' based on the zone selected, and then a separate macro to create a unique list of 'Models" based on the 'Style selected'. these macros work great when i run them from a module, but when I try to run them from the userform combo box change event i get errors.