Selecting 3 buttons out of a 3 x 3 array of options.

[Tayo]

Hi All,

I have a set of 9 option (radio) buttons arranged in 3 rows by 3 columns.
How can I use Excel to control the group of the option (radio) buttons so
that only one option can be selected in any row and any column? In other
word, I want only 3 buttons to be selected out of the total of 9. Please I
will appreciate it if you can help me out in full details. I don't know much
about Excel programming.

 

[Dave Peterson]

On a worksheet?

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

And then rightclick on an optionbutton on that group, choose Format
Control|control tab. Then assign the linked cell (if you want).

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

You can assign the Linkedcell on that properties window (if you want).