Counting CheckBoxes

S

scantor145

Excel 2003 w/Visual Basic 6.3

I have a form with many check boxes. I want to know how man
checkboxes the user has selected.

All names of checkboxes start with "chk".

I tried the following :


Code
-------------------
For Each Ctl In frmReagInv.Controls
If Left(Ctl.Name, 3) = "chk" And Ctl.Value = True Then
NumChem = NumChem + 1
End If
Next Ct
-------------------


but get the following message:

"Object doesn't support this property or method"

when


Code
-------------------
If Left(Ctl.Name, 3) = "chk" And Ctl.Value = True The
-------------------


is encountered.

Anything wrong with Ctl.Value?

Any other suggestions
 
T

Tom Ogilvy

For Each Ctl In frmReagInv.Controls
if Typeof Ctl is MSForms.checkbox then
If Ctl.Value = True Then
NumChem = NumChem + 1
End If
End if
Next Ctl
 

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

Top