If I have a check box on sheet1, that once it equals true, that a userform is activated.
Now within that userform, the user MUST fill out that data if the checkbox on sheet1 is to remain true. (This is ideal and is what I want to have happen).
But currently, if the user hits the red X close button at top right, it will indeed unload the userform and close it (as it should), BUT the check box remains checked.
How do I trap to see if the user hit the close button and if they did, to uncheck the box on sheet?
Bookmarks