VBA code for check boxes in a form

[HKS]

I created a form with 10 check boxes in Excel. The CheckBox name is index 1
to 10. Then, I wrote a For next statement in the VBA code to list the checked
CheckBox(s). However, I encounter problem at the below code (the macro will
not recognize the "CheckBox(X)"). Why?

For X = 1 To 9
If CheckBox(X) = True Then
Y = Y + 1 'Array counter
ReDim Preserve vArraychoice(0 To Y)
vArraychoice(Y) = CheckBox(X).Caption
End If
Next X


Thanks,
HK

 

[Dave Peterson]

In a userform?

You could use:

if me.controls("Checkbox" & x).value = true then

 

[HKS]

Thanks a lot Dave!, it works

In a userform?

You could use:

if me.controls("Checkbox" & x).value = true then