VBA code to stop printing if an Error is found

[CharterJP]

Hi Excel'ers

I am creating a form in excel and I am trying to build an error check into the print button.

Currently what happens now is if it finds an error (ex. someone leaves a field blank) a message box comes up to inform the user.
But instead of stopping the print process it continues to the next statement to find more errors and then prints anyway.

I know there is simple code to tell it to stop printing if and error is found after each if/then statement but am having trouble with the code. Could you point me in the right direction?

JP

[Leith Ross]

Hello JP,

Please post the code you are using.

[CharterJP]

Here it is:

Currently I just have two of the errror statments... but there will be 5 in total and I need it to stop printing if any one of the 5 have an actual error

Please Login or Register  to view this content.

[royUK]

Try

Please Login or Register  to view this content.

[CharterJP]

It works Great!!! Thank you

[royUK]

Glad we helped

[Maria Otazo]

Hi Roy! I have the same problem and canīt find the way to adapt to my project.
Here it is:

Please Login or Register  to view this content.

Same as JP, when it finds an error (ex. someone leaves a field blank) a message box comes up to inform the user.
But instead of stopping the print process (into sheet "historico") it continues to the next statement to find more errors and then prints anyway (as many times as error goes by)

I donīt know if Iīve made myself clear, hope so =D
Thanks!!
Regards from Paraguay,
Maria