I made my own little userform and I wanted to change a variable in "This
Workbook" when I hit the cancel button on the user form.

Does this make sense?