Counting Checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a way to count the number of checkboxes with a check in them. Can anyone help

Thanks for your time..
Steven
 
Hi
you already receivend an answer to this 1 hour ago in your previous
thread
 
If they are in a userform then try this

Dim ctl As Control
Dim A As Long
A = 0
For Each ctl In UserForm1.Controls
If TypeOf ctl Is MSForms.CheckBox Then
If ctl.Value = True Then A = A + 1
End If
Next
MsgBox A
 
I know. I apologize. When I refreshed to check and see if i recieved any responses i didn't see it posted. I was in a bit of a hurry when I psted it, I thought maybe i forgot to submit.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CheckBox 2
Code to display a true or false value in the cell containing a check box 1
Beginner - Click a checkbox then calculation to be done automatically 1
Excel macro 0
Change event does not fire 3
counting checkboxes 4
Can Checkboxes trigger the Worksheet_Change code? 3
Catching check/uncheck event accross multiple checkboxes 7

Back
Top