Data Entry Form with Multiple Checkboxes

I'm creating an Excel Data Entry form with checkboxes and I would like to allow the user to select multiple checkboxes so the Excel cell reads "Multivitamin, Vitamin D, etc." instead of just "Multivitamin"

Here's the code that is currently only adding the information from the first selected checkbox instead of multiple selected checkboxes

Please Login or Register  to view this content.

Sample Excel worksheet:
Worksheet.jpg

User form:
UserFormScreenshot.jpg

Hi GraceAnna,

I'm not sure if this is the answer maybe you need to make a true/false statement when checkbox is checked off.

https://analysistabs.com/vba-code/ex...form/checkbox/


So I think you may need to modify your code:

Please Login or Register  to view this content.

Hope this helps.

Thank you! Now it's working

Please Login or Register  to view this content.