Enabling/Disabling ComboBox

[blei]

Hi,

I have created 2 Radio Buttons and 2 ComboBoxes (Form Controls used) on an Excel Worksheet and what i what to happen is, if i click on RadioButton1 it will enable ComboBox1 and disable the ComboBox2 and vice-versa. If none of the two radio buttons are selected, both ComboBoxes are also Disabled.

[AlphaFrog]

You would need a third option Button labled None to deselect the other two.

Assign this macro to all three option buttons.

Please Login or Register  to view this content.

The index numbers (1 and 2) are the number of the option button or combobox in the order they were created.

[blei]

thanks AlphaFrog