Add Up Check Box

[Kyle]

I need help on adding up number of check mark box in a row.
I have a row contains 31 check box. I would like to add
up how many check box the user check in that row and give
me a total. (Example total 5 out of 31)

Thanks for any help.

 

[Tom Ogilvy]

Link the checkboxes to 31 cells, then use countif(range,true)

 

[Bob Phillips]

Kyle,

Here's a VBA way

Dim chk As CheckBox
Dim i As Long

For Each chk In ActiveSheet.CheckBoxes
If chk.Value = xlOn Then _
i = i + 1
Next chk

MsgBox i & " checkboxes set"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)