I want to be able to count the number of checked boxes in a form?

I have a form that has approx. 100 check off boxes. When the forms come back
to me I need to be able to count the boxes that are checked off. I can't get
the check box to be inside of the cell. So the count formula doesn't work.
Any suggestions??? (I'm a new used to Excel 2003 but am very familiar with
XP.)
THANKS so much!

Link each checkbox to a cell, and then count those cells. If it is a forma
checkbox, this will link them to AZ1:AZn

Sub cbs()
Dim i As Long

For i = 1 To ActiveSheet.CheckBoxes.Count
ActiveSheet.CheckBoxes(i).LinkedCell = "AZ" & i
Next i
End Sub


and count with

=COUNTIF(AZ:AZ,TRUE)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"cldavis" <[email protected]> wrote in message
news:[email protected]...
> I have a form that has approx. 100 check off boxes. When the forms come
back
> to me I need to be able to count the boxes that are checked off. I can't
get
> the check box to be inside of the cell. So the count formula doesn't
work.
> Any suggestions??? (I'm a new used to Excel 2003 but am very familiar
with
> XP.)
> THANKS so much!

I know how to link in XP but when I copy the check box and then try to Paste
Special, there isn't a place to paste / link. So still am unable to make
this happen. Can you tell me how to past / link or whatever else you have to
use in 2003. The formula part was no problem. THANKS!!

"Bob Phillips" wrote:

> Link each checkbox to a cell, and then count those cells. If it is a forma
> checkbox, this will link them to AZ1:AZn
>
> Sub cbs()
> Dim i As Long
>
> For i = 1 To ActiveSheet.CheckBoxes.Count
> ActiveSheet.CheckBoxes(i).LinkedCell = "AZ" & i
> Next i
> End Sub
>
>
> and count with
>
> =COUNTIF(AZ:AZ,TRUE)
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "cldavis" <[email protected]> wrote in message
> news:[email protected]...
> > I have a form that has approx. 100 check off boxes. When the forms come
> back
> > to me I need to be able to count the boxes that are checked off. I can't
> get
> > the check box to be inside of the cell. So the count formula doesn't
> work.
> > Any suggestions??? (I'm a new used to Excel 2003 but am very familiar
> with
> > XP.)
> > THANKS so much!
>
>
>

Also - I don't want to use a Check "Symbol" (Insert...Symbol) I have to use
the forms toolbar and insert a real check box. It becomes an object rather
than an entry into a cell.

"Bob Phillips" wrote:

> Link each checkbox to a cell, and then count those cells. If it is a forma
> checkbox, this will link them to AZ1:AZn
>
> Sub cbs()
> Dim i As Long
>
> For i = 1 To ActiveSheet.CheckBoxes.Count
> ActiveSheet.CheckBoxes(i).LinkedCell = "AZ" & i
> Next i
> End Sub
>
>
> and count with
>
> =COUNTIF(AZ:AZ,TRUE)
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "cldavis" <[email protected]> wrote in message
> news:[email protected]...
> > I have a form that has approx. 100 check off boxes. When the forms come
> back
> > to me I need to be able to count the boxes that are checked off. I can't
> get
> > the check box to be inside of the cell. So the count formula doesn't
> work.
> > Any suggestions??? (I'm a new used to Excel 2003 but am very familiar
> with
> > XP.)
> > THANKS so much!
>
>
>

Re-read my response.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cldavis" <[email protected]> wrote in message
news:[email protected]...
> Also - I don't want to use a Check "Symbol" (Insert...Symbol) I have to
use
> the forms toolbar and insert a real check box. It becomes an object
rather
> than an entry into a cell.
>
> "Bob Phillips" wrote:
>
> > Link each checkbox to a cell, and then count those cells. If it is a
forma
> > checkbox, this will link them to AZ1:AZn
> >
> > Sub cbs()
> > Dim i As Long
> >
> > For i = 1 To ActiveSheet.CheckBoxes.Count
> > ActiveSheet.CheckBoxes(i).LinkedCell = "AZ" & i
> > Next i
> > End Sub
> >
> >
> > and count with
> >
> > =COUNTIF(AZ:AZ,TRUE)
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "cldavis" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a form that has approx. 100 check off boxes. When the forms
come
> > back
> > > to me I need to be able to count the boxes that are checked off. I
can't
> > get
> > > the check box to be inside of the cell. So the count formula doesn't
> > work.
> > > Any suggestions??? (I'm a new used to Excel 2003 but am very familiar
> > with
> > > XP.)
> > > THANKS so much!
> >
> >
> >