Control Arrays?

[jaynorman46]

Im creating a Form In the VBA editoror and it wont let me create a control array of multiple option buttons within a frame. Can you no longer Create control arrays?

I appreciate your help!

 

[Norie]

As far as I know you never could in VBA.

Which I think surprised a lot of people who were used to VB6 and were now trying to work with VBA.

And guess what they apparently dropped them in VB.NET.

 

[jaynorman46]

Thanks for your response! Do you have any suggestions about coding with multiple option buttons? Im trying to avoid hard coding and multiple if then statements. Im not looking for anything specific...anything will help...

 

[Norie]

I suppose it depends on what you want to do with them.

One way might be to create a class which will allow you to handle some of the events associated with the buttons centrally.

I think the only thing I've done with a class and option buttons was some trivial thing that changed their backgrounds when one of them was clicked.

ie when an option button was clicked it's background went red and the rest changed to the form background colour