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.
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.
