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!

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

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" wrote in message
...
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 want to be able to count the number of checked boxes in a fo
 

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" wrote in message
...
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 want to be able to count the number of checked boxes in a fo
 

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" wrote in message
...
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 want to be able to count the number of checked boxes in a fo
 

Re-read my response.

--

HTH

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


"cldavis" wrote in message
...
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" wrote in message
...
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!