Disable Control Checkboxes based on Option Button result

[BJ]

Hello All

I have two option buttons in a spreadsheet.

When one of these option buttons is selected, I'd like to disable several
control checkboxes.

How can I accomplish this?

Thanks.

BJ

 

[dman]

Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then
CheckBox1.Enabled = False
End If
End Sub

 

[BJ]

if I'm disabling multiple checkboxes are the additional conditions just added
or is there additional syntax required?

I added the multiple lines and nothing is working - i.e. the checkboxes are
not being disabled. Thanks.

e.g.,

Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then
CheckBox1.Enabled = False
CheckBox2.Enabled = False
End If

 

[BJ]

Thanks dman

I think I figured it out ... appreciate the help.

BJ