Can I use more than one set of option buttons in a worksheet?

[Ray]

In order to use option control buttons in a single worksheet to control more
than one sort of choice, how do I get new buttons to return a new set of
sequential numbers?

 

[Chip Pearson]

I'm not clear what your question is, but you might try enclosing
your option buttons in a Group Box or Frame control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dave Peterson]

Just to add to Chip's response:

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.