Indexing Through ACTIVEX Comboboxes

Originally Posted by Hemimud

I think this would work fine for a userform, just not an ACTIVEX control.

FortySixAndTwo's code is for ActiveX controls. The controls on a userform are the same as you are using, the code fails since there is no controls collection of the Worksheet Object.

The other type of controls are forms controls, which are IMO better choices for use on a worksheet as they tend to be more stable than ActiveX controls

Using tiger's explanation, you can do this:

For x = 1 to 5
   me.OLEobjects("CheckBox" & x).visible=False
Next x