Disable Control Checkboxes based on Option Button result
 

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

Disable Control Checkboxes based on Option Button result
 

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

"BJ" [No Spam Please] wrote in message
...
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

Disable Control Checkboxes based on Option Button result
 

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

"dman" wrote:

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

"BJ" [No Spam Please] wrote in message
...
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

Disable Control Checkboxes based on Option Button result
 

Thanks dman

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

BJ

"dman" wrote:

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

"BJ" [No Spam Please] wrote in message
...
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