checkbox error msg

**waltron** · 05-09-2010, 11:43 PM

hello there

I have 3 check boxes on a userform ckbox 1 is enabled at all times ckbox 2 & 3 become enabled when ckbox 1 is chosen (it's an option with 2 sub options), then either ckbox2 or 3 is selected but not both. I need a msgbox to appear when command button 1 is clicked if ckbox2 or 3 not both hasn't been selected whilst ckbox1 is selected. i hope this makes sense

thanks

**pike** · 05-10-2010, 12:12 AM

why use option buttons in a frame so that only one can be checked?

but for your answer

Private Sub CheckBox2_Click()
If CheckBox3 = True And CheckBox2 Then
MsgBox " You have check 3"
End If
End Sub

Private Sub CheckBox3_Click()
If CheckBox2 = True And CheckBox3 = True Then
MsgBox " You have check 2"
End If
End Sub