Exit a loop from within a user form.

The sub “CheckDate” in module 10 has a For Each loop. Within the loop a user form “frmFollowUp” is called. If I use “Unload Me” or “frmFollowUp.Hide” in the “Cancel” command button the current form closes but the loop carries on bringing up the user form again as part of the continuing loop.
What code in the “Cancel” command button can I use to close the user form and exit the loop as well?
The attached spreadsheet has the user form and part of the loop code.

well of course the loop carries on! you are not terminating it. so are you wanting to terminate the code when the form is closed/unloaded the FIRST time? when you show a form like the way you are doing, code execution halts because the form is what is called a dialog. and a dialog takes precedence over literally anything else. that's why the form doesn't reload and the loop continues until you close it. thus, if what I speculate you want is true, you can do it a countless number of ways. one way, which comes to my mind, is to check a global var. a boolean perhaps. so, for instance, you would write this in the primary module:

Please Login or Register  to view this content.

and then, you would write this behind your cancel button:

Please Login or Register  to view this content.

and then, you would write this at the end of your primary routine before the loop begins its next go-round:

Please Login or Register  to view this content.

Thanks that worked exactly as I wanrted it to. Cheers Sandy

good luck sandy.