activeX controls

[Man on fire]

Good day all,

I have 2 activeX controls in a groupbox, a checkbox and 2 option buttons in an excel spread sheet.

I would like the 2 option buttons to be greyed out if check box is not checked, but if the checkbox is checked, it should activate and the user should be able to choose a option button.

Thank you very much.

Man On Fire.

 

[pbornemeier]

This code should be placed on the codepage of the worksheet that contains the controls.

Option Explicit

Private Sub CheckBox1_Click()
    If CheckBox1 Then
        OptionButton1.Enabled = True
        OptionButton2.Enabled = True
    Else
        OptionButton1.Enabled = False
        OptionButton2.Enabled = False
    End If
End Sub