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

>-----Original Message-----
>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
>.
>

Hi Keri,

Keri wrote:
> 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!

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)