Disabling grouped option boxes based on combo box selection

samuelle

New Member
Joined
Aug 19, 2015
Messages
3
Hi all,

I've found similar questions to this (disabling option buttons based on listbox etc.) but have tried all their code and tinkering about and can't get it to work. Apologies, I am quite new to this.

I have a combo box, with 6 options. Depending on the selected option, a certain number of grouped option buttons will be enabled or disabled. I have tried the following code in the combo box section but think I'm probably way off the mark. Opt1NYM is just one of the options available within a group frame, should I be attempting to disable the frame or each individual option?

Private Sub comboAP_Change()
If comboAP.Value = "AP1 (Due Friday 16th October, 2015)" Then
Opt1NYM.Enabled = True
Else
Opt1NYM.Enabled = False
End If
End Sub

Any help would be most appreciated.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,132,790
Messages
5,655,318
Members
418,189
Latest member
sam1123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top