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.
Bookmarks