[RESOLVED] Question regarding Controls

[Sacto95827]

Presently, I have a number of checkbox controls appropriately named:

CheckBox1
CheckBox2
CheckBox3
CheckBox4
etc.

Is there a way to use and array and loop to assign the name of the control instead of continually put a bunch of if's and else's. For example, this is what I have now:

If ActiveCell.Value = "NC" Then
     CheckBox1.Value = False
Else
     CheckBox1.Value = True
End If
 
If ActiveCell.Value = "NC" Then
     CheckBox2.Value = False
Else
     CheckBox2.Value = True
End If

I can put the rest of the If's and Else's...but that's just bad programming. Any suggestions would be greatly appreciated!