Userform Macro to stop Main sub?

I am setting up a work rotation spreadsheet that will allow me to create our rotation at the click of a button once I've filled out some data prior too (position, dates, etc...)

Now I have a Userform that will pop up and ask me to replace a body if they are working the exact same day two weeks in a row (i.e.. If they worked Tuesday one week, they can't work it again the next week) by using a combobox.

Now if someone cancels the userform without selecting anything from the combobox is there a command I could use that would not only stop the userform macro, but the original macro that pointed to it? I've thought about just using an empty cell to put a 1/0 in to show if a selection was made or not, but in the spirit of learning, I'd figure I'd try and find out if there was actual code to do something like this.


Simple Explanation of Problem:
Main Macro Runs ----> Needs to replace someone ----> Main Macro opens Useform to allow selection ----> Person decides to exit out/Cancel without making a selection ----> Userform macro realizes it's empty so exits ----> Main macro keeps on a truckin..

What I'd like to see happen:
Main Macro Runs ----> Needs to replace someone ----> Main Macro opens Useform to allow selection ----> Person decides to exit out/Cancel without making a selection ----> Userform macro realizes it's empty so exits ----> Main macro stops also..

It certainly can be done, but it is hard to suggest an answer without seeing the code for both the user form and the main macro. Can you post a dummy workbook with sensitive info taken out?

I add a read-only property to the userform to determine whether the user decided to cancel the form. I also assume the default action is to cancel.

userform with 2 command buttons.
CommandButton1 caption is "Cancel"
commandbutton2 caption is "Continue"

userform code

Please Login or Register  to view this content.

Standard code module.

Please Login or Register  to view this content.

I've uploaded my spreadsheet with the names changed (to protect the innocent).

Start on the Planner Sheet

The Picture of the Calendar is where I have the macro assigned to.


This is incomplete so I hope you don't run into any problems. But if you want to step through it you can see about midway through the code an area that shows "find someone else for a bye week." This is where it opens the userform to allow the person to manually select the person. And please don't make fun of the code I'm still pretty raw at this.