Multiple range selection in a Combo Box

Question

I am trying to use a Combo Box (Form Control) to select from a multiple of ranges depending on the item selected in another combo box.  I have tried a couple of functions (CHOOSE / INDIRECT) but the input range does not retain the function.  Can anyone assist?

Answer 1

Thanks for this information. I wanted to use the combobox feature because of the cell-link feature which generated a number for items in the primary selection and therefore a simple numerical source for using the “Choose” command in subsequent formula. 

Data Validation was the method I originally worked with but it seemed the combobox offered some better outcomes. I’ll explore the ActiveX options.  Thank you again.

Answer 2

It is hard to accomplish that with Form controls, because you need cell references, formulas and VBA code. And at the end the result is not nice.

Much easier are ActiveX controls, have a look into this file:

https://www.dropbox.com/s/hwi91qpjgh2nb8j/Cascade%20ComboBox.xls?dl=1

Andreas.