Exit Sub Procedure when called on Sub Procedure Exits

Hi all,

I hope you can help me.

Is there a way to cancel the "main" sub procedure calling on another sub procedure to do a task, when the called on sub procedure is cancelled due to validation not met?

Let me explain:

1. I have a Private Sub btnSave_click() procedure that calls on a Private Sub Validations() procedure to validate certain fields and data in my userForm.

Please Login or Register  to view this content.

2. When a validation fails in my Sub Validations() the sub exits. But this does not stop the Private Sub btnSave_click() from running the rest of the code.

Please Login or Register  to view this content.

3. How can I get both subs to exit in such a case?

Thank you in advance!

Declare a global variable that you change in the sub validations and check after returning to the sub that called it.

example:

Please Login or Register  to view this content.

Hi JasperD,

Perfect. Thank you!