combobox value depends on other combobox

[jiries1985]

as simple as this ,


can i use the same indirect function on a combobox on a userform and how i have two comboboxes 1+2 and a prenamed lists

 

[RedBeard]

This? Userform combo box options based on another combo box