iterating groups?

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

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.

--
HTH

Bob Phillips

"Mike" <[email protected]> wrote in message
news:[email protected]...
> 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
>