binding checkboxes

  • Thread starter Thread starter Keri
  • Start date Start date
K

Keri

Ok here is the issue, I want to have a checkbox that is
dependant on another checkbox. So if checkbox 1 is checked
than checkbox 2 is active, if checkbox 1 is not checked
then checkbos 2 is greyed out and isn't allowed to be
checked. I found that there was a "bound" function in VBA
but I don't know how to use it. please help!

--Keri
 
The bind function refers to the data source for the
objects so you can also set this up to change the data
source with a similar conditional statement. If you've
bound the control to a data source, a valid change in VBA
will change the source at the same time. Just set before
enable/disable.

Private Sub CheckBox1_Click()
'check1 on checked, check2 enabled
If Me.CheckBox1.Value = True Then
Me.CheckBox2.Enabled = true
Else
'check1 not checked, check2 disabled
If Me.CheckBox1.Value = False Then
Me.CheckBox2.Enabled = False
End If
End If
End Sub
 
Hi Keri,
Ok here is the issue, I want to have a checkbox that is
dependant on another checkbox. So if checkbox 1 is checked
than checkbox 2 is active, if checkbox 1 is not checked
then checkbos 2 is greyed out and isn't allowed to be
checked. I found that there was a "bound" function in VBA
but I don't know how to use it. please help!
Click to expand...

you can use this little Code:

Private Sub CheckBox1_Click()
CheckBox2.Enabled = CheckBox1.Value
End Sub

--
Regards
Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)
 
Back
Top