Pausing for input

I'm working on something that needs an input based off a graph in the middle of the macro. Some of the calculations are needed to continue. I'm opening another userform at that time in order to allow the user to input the new values then they click a button to continue. How do I pause the main macro until user input is done? Or do I need to just bring up the user form and then use input box for the values?

Hello SQChevy,

Displaying the UserForm while in the main macro will pause the macro until you close the UserForm. You must make sure the property ShowModal is set to True. This is the default setting for a UserForm. Why not input the data using TextBoxes on the UserForm rather than calling InputBoxes?

Sincerely,
Leith Ross

Well, I'm displaying a graph that the used will need to find a value based on numbers calculated after input. I was going to have another userform pop up with the graph and the number needed for the graph and have them input there.

What about if your using a userform to run the macro and open another one will it still pause?