G
Guest
Hi All,
I have an Excel sheet that has several checkboxes. I also have a command
button that when clicked the form is emailed. When the user clicks the
cammand button I need to verify that at least one checkbox in each category
is checked before the form is emailed. I tried something like:
If CheckBox1.Value = False And CheckBox2.Value = False And CheckBox3.Value =
False And CheckBox36.Value = False And CheckBox38.Value = False Then
MsgBox "Please check reason for request!"
Range("A11").Select
End If
I receive the msgbox, but when I click ok, the form is emailed even though
there isn't any checkboxes checked. I think I need code after the msgbox
line but I am not sure how to do this. Can someone help me?
I have an Excel sheet that has several checkboxes. I also have a command
button that when clicked the form is emailed. When the user clicks the
cammand button I need to verify that at least one checkbox in each category
is checked before the form is emailed. I tried something like:
If CheckBox1.Value = False And CheckBox2.Value = False And CheckBox3.Value =
False And CheckBox36.Value = False And CheckBox38.Value = False Then
MsgBox "Please check reason for request!"
Range("A11").Select
End If
I receive the msgbox, but when I click ok, the form is emailed even though
there isn't any checkboxes checked. I think I need code after the msgbox
line but I am not sure how to do this. Can someone help me?