Solved: show visible if true

[Emoncada]

How can I say in a userform that if any range of checkboxes are true then visible = True.
I have 6 Checkboxes if any 1 is True then CmdButtonUpdate.Visible = True Otherwise CmdButtonUpdate.Visible = False.

Any help would be great. Thanks

[mikerickson]

With Userform1
.CmdButtonUpdate.Visible = .CheckBox1.Value Or .CheckBox2.Value Or .CheckBox3.Value _
Or .CheckBox4.Value Or .CheckBox5.Value Or .CheckBox6.Value
End With

[Emoncada]

Cool only two things
1. Can this be a constant thing so if one is checked then unchecked for it not to be visible.
2. Can I hide a cmdbuttonclose when any of those values are true.

[mikerickson]

1) Execute that line every time any of the CheckBox_Change events trigger.

2) Yes. Just replace the name of the command button.

[Emoncada]

ok got the first one to work how can i make the 2nd one work

[Emoncada]

I want CmdButtonClose.Visible = False when Any chkboxes are True

[mikerickson]

Use

.CmdButtonClose.Visible = Not(.CheckBox1.Value Or .CheckBox2.Value...Or .CheckBox6.Value)

[Emoncada]

Ok i got it i added an if statement in the change event sub

[Emoncada]

ok that would work also thanks mikerickson