Tool Box Check Boxes

[devin]

I wrote some code that uses check boxes from the tool box. It works fine
until I copied a bunch of check boxes to my sheet. Then all my vb code
stops working. almost as if it gets disconnected. Remember, all the
code worked fine before so I don't think it's a code issue. If I run
the debug on the vb code I get "Object library Invalid or contains
references to object definitions that could not be found." Even if I
delet the check boxes the excel sheet seems disconnected. Any help
would be greatly appriciated. Thanks

 

[pikus]

Check the names of the checkboxes against those you used in your code.
If you referred to them by way of their index numbers then I recommen
renaming them something consistent like cBox1..10 and refer to them i
your code like this:

For x = 1 To 10
Worksheets("Sheet1").Controls("cB" & x).Value = False
Next