Help with Selecting multiple Checkboxes on a form
You also need to modify this line:
For Each chx In UserForm6
To:
For Each chx In UserForm6.Controls
This assumes you only have checkboxes on the form.
"Corey ...." wrote:
I am trying to use a CommnadButton on a form to Select ALL Checkboxes on a
form IF the CheckBox Caption is NOT "----------".
However i keep getting a error on the below identified line, why ?
Private Sub CommandButton2_Click()
Dim chx As CheckBox
With UserForm6
If chx.Caption < "----------" Then '<==== ERROR
For Each chx In UserForm6
chx.box = True
Next chx
End If
End With
End Sub
How can i fix this?
Corey....
|