I have created a form using checkboxes from the forms toolbox. I want to sum all boxes checked. I understand I have to link each box to a cell in order to set the value to True or False. I have several hundred boxes on the form. How do I copy/paste a box with its linked cell reference (as I do with other formulas)A1 = A1, A2 = A2 and so on. Instead,when I copy A1 to A2, A2 has the same referenced cell (A1). I have to go to each cells properties and set the cell. I'm sure there is a solution without me having to touch each box and set its properties.
Thanks in advance