In Excel97 with VBA, using CheckBox in arrays ?

[christian33]

A French teacher :

Is it possible to use CheckBox(4) instead of CheckBox4, as i need to use these controls in a loop, with a index.

Thank's for any solution, as i am a beginner with VBA.

Christian GRANDE, in BORDEAUX (FRANCE)

 

[dsi]

Unfortunatly, control arrays are not available in the Excel VBA.

 

[Databaseguy]

DSI is right. What you could do, and I have done, is:


(This is psuedo code, won't work)
For each Control in me.controls
If type of control is combobox then
'do something
Else
End If

There's a more detailed example on my web page at

http://databaseguy.hypermart.net/Dim MyString.htm#DataValidation

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy