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.


Ray wrote:

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?

--

Dave Peterson