Hi Corey,

If you want to use the variable instead of the checkbox name you need to
assign a checkbox to it first otherwise how does it know which checkbox
caption you are referring to. Because you are using chx in the For Each loop,
perhaps simply using the actual name of the checkbox to identify the caption.


--
Regards,

OssieMac


"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....