Can ALL option buttons within a frame be tied together for common THEN

The standard way to do this is to add code to each Click event handler for each button. There's no way around it. If there is an action that you want to take when any of the buttons are clicked, then you have to detect a click event for all of the buttons.

There is another more sophisticated way to do that with classes. You have to create a Class module that defines an option button and will handle a Click event for any option button that is allocated to the class. It's a little tricky for someone new at VBA. This technique is described by John Walkenbach in Excel 2003 Power Programming With VBA and is shown here.

I'm not sure what you mean by a control array. Do you mean an array of type Control? I don't know what you're reading but the language is the same in 2003 and forward. Some things have changed in the object model, like toolbars go away in 2007 with the introduction of the ribbon, but arrays, data types. control structures are all the same.

Please Login or Register  to view this content.

Or you can use a class to handle (Withevents) the click events of all optionbuttons.

Originally Posted by teacher_rob

i am reading up on control arrays... sounds like excel 2003 doesn't have this ?

Control arrays are not supported in VBA at all, no. But VB6, yes.