Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
iterating checkboxes | Excel Discussion (Misc queries) | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
Iterating Thru Cells | Excel Programming | |||
Iterating through cells problem | Excel Programming |