In Excel, how to count a list of check boxes some are checked?

I have a list of names/accounts, in front of each there's a check-box which
tells if the account was completed or not (checked or cleared - false or
true). How can I count the total of checked and/or unchecked check boxes?
Thank you

Link the checkboxes to cells, and then just sum those values.

If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
checkboxes set a value of 1 or 0.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" <M. [email protected]> wrote in message
news:[email protected]...
> I have a list of names/accounts, in front of each there's a check-box
which
> tells if the account was completed or not (checked or cleared - false or
> true). How can I count the total of checked and/or unchecked check boxes?
> Thank you

Thanks for answering, I had to put many check-boxes in the same sheet, so I
just copied and pasted the first one I created, so they're all linked to the
same cell, that's actually the issue I'm having, to link each check box to a
different cell..."
Thanks a lot

"Bob Phillips" wrote:

> Link the checkboxes to cells, and then just sum those values.
>
> If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
> checkboxes set a value of 1 or 0.
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "M. Zak" <M. [email protected]> wrote in message
> news:[email protected]...
> > I have a list of names/accounts, in front of each there's a check-box
> which
> > tells if the account was completed or not (checked or cleared - false or
> > true). How can I count the total of checked and/or unchecked check boxes?
> > Thank you
>
>
>

What sort of checkboxes, forms or control toolbox?


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" <[email protected]> wrote in message
news:[email protected]...
> Thanks for answering, I had to put many check-boxes in the same sheet, so
I
> just copied and pasted the first one I created, so they're all linked to
the
> same cell, that's actually the issue I'm having, to link each check box to
a
> different cell..."
> Thanks a lot
>
> "Bob Phillips" wrote:
>
> > Link the checkboxes to cells, and then just sum those values.
> >
> > If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
> > checkboxes set a value of 1 or 0.
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "M. Zak" <M. [email protected]> wrote in message
> > news:[email protected]...
> > > I have a list of names/accounts, in front of each there's a check-box
> > which
> > > tells if the account was completed or not (checked or cleared - false
or
> > > true). How can I count the total of checked and/or unchecked check
boxes?
> > > Thank you
> >
> >
> >

Control toolbox

"Bob Phillips" wrote:

> What sort of checkboxes, forms or control toolbox?
>
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "M. Zak" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks for answering, I had to put many check-boxes in the same sheet, so
> I
> > just copied and pasted the first one I created, so they're all linked to
> the
> > same cell, that's actually the issue I'm having, to link each check box to
> a
> > different cell..."
> > Thanks a lot
> >
> > "Bob Phillips" wrote:
> >
> > > Link the checkboxes to cells, and then just sum those values.
> > >
> > > If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
> > > checkboxes set a value of 1 or 0.
> > >
> > > --
> > >
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from the email address if mailing direct)
> > >
> > > "M. Zak" <M. [email protected]> wrote in message
> > > news:[email protected]...
> > > > I have a list of names/accounts, in front of each there's a check-box
> > > which
> > > > tells if the account was completed or not (checked or cleared - false
> or
> > > > true). How can I count the total of checked and/or unchecked check
> boxes?
> > > > Thank you
> > >
> > >
> > >
>
>
>

This code will link all your CBs to cells in column M

Sub LinkCBs()
Dim i As Long
Dim obj As OLEObject

With ActiveSheet
For Each obj In .OLEObjects
If TypeName(obj.Object) = "CheckBox" Then
i = i + 1
obj.LinkedCell = "M" & i
End If
Next obj
End With
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" <[email protected]> wrote in message
news:[email protected]...
> Control toolbox
>
> "Bob Phillips" wrote:
>
> > What sort of checkboxes, forms or control toolbox?
> >
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "M. Zak" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thanks for answering, I had to put many check-boxes in the same sheet,
so
> > I
> > > just copied and pasted the first one I created, so they're all linked
to
> > the
> > > same cell, that's actually the issue I'm having, to link each check
box to
> > a
> > > different cell..."
> > > Thanks a lot
> > >
> > > "Bob Phillips" wrote:
> > >
> > > > Link the checkboxes to cells, and then just sum those values.
> > > >
> > > > If it is Forms checkboxes set a value of TRUE or FALSE, control
toolbox
> > > > checkboxes set a value of 1 or 0.
> > > >
> > > > --
> > > >
> > > > HTH
> > > >
> > > > Bob Phillips
> > > >
> > > > (remove nothere from the email address if mailing direct)
> > > >
> > > > "M. Zak" <M. [email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I have a list of names/accounts, in front of each there's a
check-box
> > > > which
> > > > > tells if the account was completed or not (checked or cleared -
false
> > or
> > > > > true). How can I count the total of checked and/or unchecked check
> > boxes?
> > > > > Thank you
> > > >
> > > >
> > > >
> >
> >
> >

Hi Bob; thanks a lot it's working, now I can count how many false and how
many true for my checkboxes, I just didn't include the first line in my new
sub_code:"Sub LinkCBs()" now it works..thanks again

"Bob Phillips" wrote:

> This code will link all your CBs to cells in column M
>
> Sub LinkCBs()
> Dim i As Long
> Dim obj As OLEObject
>
> With ActiveSheet
> For Each obj In .OLEObjects
> If TypeName(obj.Object) = "CheckBox" Then
> i = i + 1
> obj.LinkedCell = "M" & i
> End If
> Next obj
> End With
> End Sub
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "M. Zak" <[email protected]> wrote in message
> news:[email protected]...
> > Control toolbox
> >
> > "Bob Phillips" wrote:
> >
> > > What sort of checkboxes, forms or control toolbox?
> > >
> > >
> > > --
> > >
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from the email address if mailing direct)
> > >
> > > "M. Zak" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Thanks for answering, I had to put many check-boxes in the same sheet,
> so
> > > I
> > > > just copied and pasted the first one I created, so they're all linked
> to
> > > the
> > > > same cell, that's actually the issue I'm having, to link each check
> box to
> > > a
> > > > different cell..."
> > > > Thanks a lot
> > > >
> > > > "Bob Phillips" wrote:
> > > >
> > > > > Link the checkboxes to cells, and then just sum those values.
> > > > >
> > > > > If it is Forms checkboxes set a value of TRUE or FALSE, control
> toolbox
> > > > > checkboxes set a value of 1 or 0.
> > > > >
> > > > > --
> > > > >
> > > > > HTH
> > > > >
> > > > > Bob Phillips
> > > > >
> > > > > (remove nothere from the email address if mailing direct)
> > > > >
> > > > > "M. Zak" <M. [email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > I have a list of names/accounts, in front of each there's a
> check-box
> > > > > which
> > > > > > tells if the account was completed or not (checked or cleared -
> false
> > > or
> > > > > > true). How can I count the total of checked and/or unchecked check
> > > boxes?
> > > > > > Thank you
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>