View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_98_] Mike[_98_] is offline
external usenet poster
 
Posts: 1
Default 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