Check your other post.
On 08/26/2010 12:20, Dave K wrote:
> 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
|