Confirming certain fields have entries before a form can be e-mailed

[Godot60]

I have an excel form that has certain required fields (more than one) which must have data entered into them. I have created a button that emails the form to me using a VBA statement. Is there a way to prevent the form from being submitted if any of the required cells are left blank? Any assistance would be appreciated.

 

[Roxxien]

Hello,

When I learned how to program in VBA, my teacher always asked that we had a "validation" part before the real code start.
When the validation wasn't correct, it will automatically exit the sub and didn't write stuff in Excel or create Word/PDF or send email.

Some validation can be very simple and I think it would be a good solution for your problem.

If isempty(textbox1) then
msgbox "Plz fill box1"
Exit sub
End if

 

[Godot60]

This worked great on one cell ! Any idea how to add more cell references to the statement so that it checks them as well? Thanks for your help.

 

[Roxxien]

What are talking about for "the statement"?

If it's this simple test, you can have the following or simply copy paste it as much as you need.

[COLOR=#333333]If isempty(textbox1) OR isempty(textbox2) OR isempty(textbox3) then
[/COLOR]msgbox "Plz fill correctly this userform"
Exit sub
End if