Userform Open Close Help

**dgibney** · 02-16-2017, 03:49 PM

I've configured a workbook to open each time on the "Instructions" page. When users then click on another worksheet a UserForm Popup box activates asking the viewer to either "Accept" or "Decline" terms by checking one of two checkboxes. I would like to rewrite the code to close the workbook if they "Decline", and if they "Accept", to not show the PopUp box again if/when they navigate back to the "Instructions" page and then again to another worksheet.

Also, it would be great if the user did not have to manually close the PopUp Userform when Accepting or Declining, if that's possible.

Here is my code thus far.

Please Login or Register  to view this content.

Any insights are much appreciated, as always. Thanks David

**davesexcel** · 02-16-2017, 04:52 PM

Please Login or Register  to view this content.

**dgibney** · 02-16-2017, 05:07 PM

Can you provide more detail please?

**Arkadi** · 02-16-2017, 05:10 PM

dgibney, davesexcel was giving an example of how to unload a userform. We assume the "popup" is a userform? from within a userform you can use "Unload Me", if code outside the userform is to get rid of the form then the syntax is "Unload UserForm1" where UserForm1 is the actual name of the userform.

So at the end of the code for the checkboxes just put a line of code with the unload command.

**davesexcel** · 02-16-2017, 05:14 PM

Ah, I got distracted,
I was just replying to how to unload a userform so the user does not have to.

I wasn't going to get into the first part of the question. Those kind of things are cool at the beginning, but tend to get very annoying quickly.

**dgibney** · 02-16-2017, 05:25 PM

Thanks for your explanation. I'm still not having the results I'd like. Here is what I did based on your input:

Please Login or Register  to view this content.

Does anything pop out? Thanks again. David

**Logit** · 02-16-2017, 05:54 PM

Make a copy of the project BEFORE running it, cuz you can't get the UserForm back again after clicking ACCEPT.

Paste this code into a UserForm1 that has Checkbox 1 and Checkbox 2 :

Please Login or Register  to view this content.

This code goes in Sheet INSTRUCTIONS :

Please Login or Register  to view this content.

The code checks whether the user checks Accept or Decline. If DECLINE, the UserForm unloads and the workbook auto-closes.

If the User checks ACCEPTS, the UserForm is deleted from the project and access to the remainder of the project continues.