How do I set up a second set of option buttons in Excel?

D

Defoes Right Boot

I've got one set of option buttons (call them options A, B, C and D) - of
which the user can only select one, and they send the selection result to a
linked cell.

But if I try and set up a second set (say E, F, G and H), again one of which
can be selected, how can I do it so this is completely independent of the
first set? Whatever I do Excel seems to insist on grouping the whole lot
together.

Hope someone can help!
 
D

Dave Peterson

If you used optionbuttons from the Forms toolbar, put a nice groupbox (also from
the forms toolbar) around each group.

If you use optionbuttons from the control toolbox toolbar, go into design mode
(icon on that same toolbar) and rightclick and provide a unique groupname
property for each optionbutton group.

(each optionbutton within the same group should have the same groupname--but
different than the other groups (did that last sentence help????))

The default groupname is the sheet name, so they're all grouped together.

===
If you used option buttons from the Forms toolbar, make sure they are completely
within each groupbox.
 
D

Defoes Right Boot

Brilliant, thanks! Ridiculously easy, but could I find it in the help file??
Could I *****!

Thanks again!
 
Top