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!