Userform cancel button - how to exit multiple subs

Hello,

I have a spreadsheet that generates a report in Word depending on what users select in a userform.

The architecture is like this:

master macro - runs/calls all the macros below

macro 1 - displays the userform
macro 2 - does stuff based on the userform input
macro 3 - does more stuff
....
macro 8 - generates report


The problem I am having is with the cancel button (the red x in the top corner). If I click on the cancel button, the userform disappears, then macro 2 runs,
then macro 3 runs
then macro 4 runs
all the way until the last macro.

Is there anyway to stop ALL the macros running, if the user presses cancel on the userform?

This is really driving me crazy. I don't want to add a "Cancel" command button, or hide the red x, or reassign it. I just need some code to make it stop all macros.

Any help greatly appreciated...

Originally Posted by romperstomper

Don't just use End. Ever.
You should trap the X button using the QueryClose event of the form and trigger your own Cancel routine as a result of it. Do you already have a Cancel button?

Hi guys, thanks for the suggestions. Romperstomper, what is the syntax for QueryClose?

I am assuming you mean in the master macro I put something like -

if the userform was closed with the cancel button, then don't do anything
else
run the rest of the macros


Is that right? Do I need to add anything to the userform code?

Really sorry for my ignorance, I've been using vba for a while but have only recently started using userforms.

That's excellent, mate. Cheers I'll give it a go now.
What is the syntax for running this from the red x button in the top corner, rather than through a "cancel" command button I place on the userform?
Any idea? If not, I'll go with what you have written...

Hey mate

I got it working (using your original code) - sorry, I didn't realize the original code was referencing the red x button.

I too, much prefer it with a working red x button.

You sir, are a legend.

Thank you