I would like to enable and disable ComboBox selection in my Excel workbook.
There are three ComboBoxes. The user will make a choice of two items in an initial ComboBox. If item A is selected then ComboBox A is enabled and ComboBox B is disabled. If item B is selected then ComboBox B is enabled and ComboBox A is disabled.
Is there code such as:
ComboBox.Enabled = true
I want the initial ComboBox to fire a macro to enable and disable ComboBoxes A and B.