Inserting Multiple Checkboxes....is there a better way

[Mark McInerney]

Hi All,

I have data in row a1 thru a100. I need to insert checkboxes that will allow me to sum only the items that are checked.

Using the developer TAB I enter a checkbox, press Enter and copy fill it down. This inserts 100 checkboxes. Is there a smart way for me to format control, and assign Cell b1 thru b100 as true or false depending on whether the checkboxes are ticked?

Any help appreciated.

Mark.

 

[korhan]

I am not sure if this would help you but wanted to share anyways
https://www.youtube.com/watch?v=RNU_JGRDmSU

 

[JLGWhiz]

Have you tried using AutoSum in the following manner?
1. Place the mouse pointer (cursor) in the cell where you want the total value to appear.
2. Click the AutoSum button on the menu display for Home on the ribbon.
3. Before pressing any other keys, press delete key once.
4. Press and hold Ctrl key while making cell selections in range to be summed.
5. When all selections are complete, press enter.
6. Total appears in cell
Might be as good as 100 check boxes and writing the code to execute them.