Good afternoon.
I am familiar with assigning a cell or range of cells using the "Define Name" method and then using that name in "RowSource" of a ComboBox. What I am wondering is if there is a way to have the ComboBox refer to a different "name" based on the selection of a different combobox.
For example: With "ComboBox1" I select from the dropdown options (Ford, Chevy, Dodge) and then with "ComboBox2" my options change to the dropdown appropriate to the selection in ComboBox!.
What would be the most efficient way to approach this? Some ComboBox's would have more choices than others.
My first thought was to tie the combobox to an "IF" command but I don't know how to point the "Rowsource" to the different named cells
Maybe there is a cleaner way to do this.
I appreciate any assistance
I am familiar with assigning a cell or range of cells using the "Define Name" method and then using that name in "RowSource" of a ComboBox. What I am wondering is if there is a way to have the ComboBox refer to a different "name" based on the selection of a different combobox.
For example: With "ComboBox1" I select from the dropdown options (Ford, Chevy, Dodge) and then with "ComboBox2" my options change to the dropdown appropriate to the selection in ComboBox!.
What would be the most efficient way to approach this? Some ComboBox's would have more choices than others.
My first thought was to tie the combobox to an "IF" command but I don't know how to point the "Rowsource" to the different named cells
Maybe there is a cleaner way to do this.
I appreciate any assistance
