Code to display a true or false value in the cell containing a check box

[Dave K]

I need to place check boxes in individual cells, and then to
hopefully
show the count of checkboxes that have been checked in a range. So for
example, i need to place checkboxes in cells G14 to G25, and show the
sum of checkboxes that have been marked in Cell G26.

This will be a form that is used for manual data entry, FYI.

Is there code i can apply that will display a "1" or a "true/false"
value in the cell containing a checkbox.

(At that point, I would be able to simply perform a sum of the ones,
or a countif of the cells containing "True").

Also, is there a certain way I would need to insert the checkboxes in
the cells so that it will work correctly.

Thanks for any suggestions.

 

[Dave Peterson]

Check your other post.

I need to place check boxes in individual cells, and then to
hopefully
show the count of checkboxes that have been checked in a range. So for
example, i need to place checkboxes in cells G14 to G25, and show the
sum of checkboxes that have been marked in Cell G26.

This will be a form that is used for manual data entry, FYI.

Is there code i can apply that will display a "1" or a "true/false"
value in the cell containing a checkbox.

(At that point, I would be able to simply perform a sum of the ones,
or a countif of the cells containing "True").

Also, is there a certain way I would need to insert the checkboxes in
the cells so that it will work correctly.

Thanks for any suggestions.