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

--
Regards
Frank Kabel
Frankfurt, Germany


Steven wrote:
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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steven" wrote in message ...
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

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.

1, 2, 3, 4 . . .

--
Regards,
Tom Ogilvy


"Steven" wrote in message
...
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

lol
...5, 6, 7 <vbg


--
Regards
Frank Kabel
Frankfurt, Germany


Tom Ogilvy wrote:
1, 2, 3, 4 . . .


"Steven" wrote in message
...
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