Activate only 1 combo box
Posted on 2000-03-13
In Excel 97, I have a form that has 3 comboboxes. I'd like the user to be able to choose only ONE of the combo boxes. (I have 3 combo boxes for 3 different categories, and only 1 of those can be processed).
For example, if the user chose a selection in combobox 1, but then also tried to select something in combobox 2, combobox 1 would be DESELECTED, and the new choise (combobox2) is the new selection.
Does anyone have the work around for this?