How to exit all subs when "cancel" is clicked in a vbyesnocancel dialog box

[asil66]

Hi there,

I have a Master Macro which calls on a few sub macros as per below:

Please Login or Register  to view this content.

My problem is, whenever user select "cancel" in the dialogbox, the macro will continue running Part2, Part3 and Part4. How can I amend the code such that when user click cancel in Part1, it will exit the macro entirely?

[Logit]

.
Rather than place this :

Please Login or Register  to view this content.

all in one sub .... can you break each one out to a separate sub that follows some logic ?

Example :

Leave the first call to CI_Part1

Then at the bottom of CI_Part1, give the user the opportunity to select the other macro / s ?
Do this for each of the remaining calls.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[Rick Rothstein]

Why not just make your CI_Part1 subroutine your MasterMacro_CI subroutine (since, in essence, it is the master code) and call the other subroutines from within it if the user answers Yes to your question? That way, your code will naturally end when there is no code to execute for the Cancel answer. By the way, you can remove this line of code...

ElseIf OutPut = vbCancel Then

as the If and ElseIf for vbYes and vbNo handled all the other possibilities.