I have an excel form that takes data and then uses a submit button to export the data to a new sheet (New_Part_Request).

I have a macro assigned to the submit button which calls three separate macros:
1. is an error message to notify the user that the form is not fully complete (based on a number of cells).
2. is the macro that exports to the 'new part request' sheet (data_input)
3. Is a message box that notifies the user that the form has been submitted (Part_Submission).

I am having an issue getting these to run independently of each other.
For example, when the 1st macro appears showing the user the error about the form not being complete, I would like the other two not to run as a result. What is happening now, is that the error message comes up, followed by the form being submitted and then the msgBox saying that it has been submitted.

How do I get it to run so that, if the error message appears, it stops. Else if, it gets submitted with no issues, then the 2nd and 3rd macro run.

I know its pretty basic, I just cant get the if, else if to work.

Current code for calling the macros is below:

Sub buttonClick()

Call errormsg1
Call data_input
Call Part_Submission1

End Sub


Thank you in advance.