Resetting checks, saving, and closing

I have the following macro that enters data statically into another worksheet.

Please Login or Register  to view this content.

After the data is copied and pasted, I would like for the user to be presented a box that reads "Data Has Been Entered" and have two buttons to execute the following options:

• Modify; OR
• Close

Modify would simply close the box so they can modify the check marks and hit the Submit button again.

If they choose to Close, I would like for the macro to:

• Reset all the check marks to unchecked
• Save the spreadsheet
• Close Excel

Could someone help with this?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here