Linking ActiveX Controls

[Guest]

I want to have a checkbox or two, that only become active or available for
selection when a specific option button is selected. Can / how do I do this?

 

[Dave Peterson]

I guessed that these controls were on a worksheet.

I went into designmode and double clicked on one of the optionbuttons and pasted
this code:

Option Explicit
Private Sub OptionButton1_Change()

Me.CheckBox1.Enabled = CBool(Me.OptionButton1.Value)
Me.CheckBox2.Enabled = CBool(Me.OptionButton1.Value)

End Sub