Transfer Data from Checkbox List to Summary Table

Hi Everyone,

I am new to the forum and this is my very first post so I will try my best to explain the problem.


I am creating a from where the user has to select checkbox to indicate which emergency drill was completed. if the drill is not on the list there is a field for "other" to indicate the appropriate drill. I have also created a register on another tab to provide a summary of the drills that were performed. The idea is, once the form is complete a "complete register" button is selected which transfers the relevant data to the register. My problem is, I don't know how to change my VBA to transfer the data from the checklists to the register. I also don't know how to set it up to look at the "other" option if a checkbox is not selected.

Just a note, I'm very new at this and everything I know I have thought myself through googling and YouTube videos so if possible please explain in a way for someone like me to understand

Thank you!
PS: I hope the explanation makes sense.

This might get you started.

If a drill type hasn't been selected and the Other field is empty the user will be prompted to fill the Other field.

Note, you'll probably need to change the sheet names, and it's not clear where the value for the 'Submitted By' column should come from.

Please Login or Register  to view this content.