Hello all!
I hope you're all cozy and safe at home.
I'm building a form that has multiple checkboxes in a single cell. Users fill out the form and click an Enter button. Everything they filled out is copied to another worksheet.
#1 - How do I export the checkboxes that were selected to my destination sheet? I want the selections to appear in one cell, separated by commas.
#2 - How can I prevent the Enter button from overwriting/pasting over itself in the destination sheet? I need it to go to the next empty row each time it's clicked.
#3 - When I'm done, I want to protect the worksheets. Even though the cell containing the checkboxes isn't locked, you can't interact with the checkboxes when the sheet is protected. Why is this? Is there a workaround?
An example workbook is attached. The only VBA I have so far is below:
Thank you!
Bookmarks