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

[cldavis]

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!

 

[Bob Phillips]

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]

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!!

 

[cldavis]

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]

Re-read my response.

--

HTH

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