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!