humberto
2004-09-28, 10:44 AM
Dim ctl As Control
Dim intCounter As Integer
For Each ctl In Me.Controls
If TypeOf ctl Is CheckBox Then
If ctl.Value = True Then
intCounter = intCounter + 1
End If
End If
Next ctl
msgbox intCounter
(vba)
After install Microsoft Office 2003 this not work anymore
it look also for the OptionButton
Dim intCounter As Integer
For Each ctl In Me.Controls
If TypeOf ctl Is CheckBox Then
If ctl.Value = True Then
intCounter = intCounter + 1
End If
End If
Next ctl
msgbox intCounter
(vba)
After install Microsoft Office 2003 this not work anymore
it look also for the OptionButton