Using CheckBox as element of an array in EXCEL97 VBA ?

[christian33]

Using EXCEL97, with VBA I use forty CheckBoxes.

These CheckBoxes are named by VBA, CheckBox1, CheckBox2 etc... But I would like to use them like elements of an array of CheckBoxes, using calls to CheckBox(I).value, where I is an integer, in a loop.

Is it possible, as I am a novice in VBA programs.

Thank you for any information about this.

Christian GRANDE, French teacher in Bordeaux.

 

[dsi]

Unfortunately, control arrays are not available in VBA. That would sure make it a lot easier.