Checkbox <if> <or> <and> formulas

[TeodoraNenova]

Hi, I have 7 ActiveX checkboxes and I would like to write a code to represent the following:

If Checkbox1.Value = True <OR> CheckBox2.Value = True Then Checkbox 5.Value = True
Else CheckBox5.Value = False

If checkbox 3.Value = True <OR> Checkbox4.Value = True <And> Checkbox5.Value = False Then Checkbox6. Value = True
Else Checkbox6.Value = False

If Checkbox5 <AND> Checkbox6 both = False Then Checkbox7.Value = True

--
Is this possible? Thanks!

 

[Andrew Poulsom]

When do you want to run your code? It would look like this:

    CheckBox5.Value = (CheckBox1.Value = True And CheckBox2.Value = True)
    CheckBox6.Value = (CheckBox3.Value = True And CheckBox4.Value = True And CheckBox5.Value = False)
    CheckBox7.Value = (CheckBox5.Value = False And CheckBox6.Value = False)

 

[TeodoraNenova]

Sorry, now I see my post did not come right. here is waht I want to do:

I have 7 ActiveX checkboxes and I would like to write a code to represent the following:

If Checkbox1.Value = True OR <OR>CheckBox2.Value = True Then Checkbox 5.Value = True
Else CheckBox5.Value = False

If checkbox 3.Value = True OR <OR>Checkbox4.Value = True AND <AND>Checkbox5.Value = False Then Checkbox6. Value = True
Else Checkbox6.Value = False

If Checkbox5 AND <AND>Checkbox6 both = False Then Checkbox7.Value = True

--
Is this possible? Thanks!
<!-- / message -->

 

[Andrew Poulsom]

Sure:

    CheckBox5.Value = (CheckBox1.Value = True Or CheckBox2.Value = True)
    CheckBox6.Value = ((CheckBox3.Value = True Or CheckBox4.Value = True) And CheckBox5.Value = False)
    CheckBox7.Value = (CheckBox5.Value = False And CheckBox6.Value = False)

 

[TeodoraNenova]

What happens with that code is, when I check box 1 or 2, then I am allowed to also check 5 (if 1 or 2 are flase, I cannot put a tick on 5). But what I need is, when 1 or 2 is checked, then 5 is also automatically checked. Similar for boxes 6 and 7. Would you know how to do that? Thanks a lot for your help!

 

[Andrew Poulsom]

You can do this:

CheckBox5.Value = (CheckBox1.Value = True Or CheckBox2.Value = True)
CheckBox5.Enabled = Not (CheckBox1.Value = True Or CheckBox2.Value = True)