View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You can set up a LinkedCell for each checkbox. (It's under properties when you
rightclick on the checkbox (while in design mode).)

Then you can put those in a column (hidden) in the same row as the checkbox.

then
=countif(e:e,true)
(use the correct column, though)

Tony wrote:

I have created a column that has check Boxes using the Control Toolbar. How
do I count the total number of checkc boxs in a column, that have check marks
in them. I do not know VBA, only know how to create and paste a function was
already set up for me. Thanks in advance, Tony


--

Dave Peterson