Linking ActiveX Controls

M

MikeyS

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?
 
D

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
 
Top