iterating groups?

[Mike]

Hi Folks,

Working on yet another spreadsheet, and this time I was hoping to set
up a number of groups of radio buttons I could iterate through to
conditionally sum a number of values into different groups based on
which radio button is selected.

Unfortunately, I've quickly discovered that it seems like groups can't
be referenced as objects - am I right in this? For example, with a
group Set155 with the radio buttons High, Med and Low, I discovered I
can't ref Sheet1.Set155.High, but can ref Sheet1.High. This seems to
imply that for each of my groups, I'm going to have to iterate numbers
in the radio buttons - not exactly ideal when I'm going to have a
couple of hundred groups of buttons and my real-life sheet has seven
options per group.

Is there something I'm missing? It'd be great to be able to treat these
groups as objects.

Cheers,
Mike

 

[Bob Phillips]

Mike,

If you use option buttons from the forms toolbar, and stick the grouped
items in a group control, link the buttons in a group to the same cell, you
can then just sum all the linked cells. The first item in the group returns
1 if selected, the second 2, and so on.