Add Up Check Box

  • Thread starter Thread starter Kyle
  • Start date Start date
K

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.
 
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)
 
Back
Top