Userform problem

[Roccafelie]

Hello Everyone

I am looking for a macro or code that if a field not filled or choosen in userform, there will be a error message says "cant continue, please make sure all fields are filled etc..)

I believe it s asked before, but I cant find the relevant thread.

I ll be hapy, if you could give me a hand with that

Thanks

 

[Antonio12]

OK, first of all sorry for the many replies but this is a headache already for me and possibly for you because i really don't know how to use this forum thing. I got it to work (almost and finally) but now I'm required to check both boxes instead of just one. I need something like an "if! cbx1 is not fille then cbx2 must be and if none then error": This is how I fixed part of it already:

If CheckBox1.Value = False Then
MsgBox "Por favor complete o formulário"
CheckBox1.SetFocus
Exit Sub
End If

If CheckBox2.Value = False Then
MsgBox "Por favor complete o formulário"
CheckBox2.SetFocus
Exit Sub
End If

 

[Andrew Poulsom]

Try:

If CheckBox1.Value = False Then
    MsgBox "Por favor complete o formulário"
    CheckBox1.SetFocus
    Exit Sub
ElseIf CheckBox2.Value = False Then
    MsgBox "Por favor complete o formulário"
    CheckBox2.SetFocus
    Exit Sub
End If

 

[Antonio12]

Dear Mr. A. Poulson: Thank you for all your help but that did not work either. I finally figured it out. Here's the code for you.

If CheckBox1.Value = False And CheckBox2.Value = False Then
MsgBox "Por favor complete o formulário"
CheckBox1.SetFocus
Exit Sub
End If
If CheckBox2.Value = False And CheckBox1.Value = False Then
MsgBox "Por favor complete o formulário"
CheckBox2.SetFocus
Exit Sub
End If

 

[Andrew Poulsom]

Sorry, I misunderstood. You only need the first block If ... End If.