LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Sorting groups in groups due to subtotaling [email protected] Excel Worksheet Functions 3 April 4th 08 06:13 PM
iterating checkboxes [email protected] Excel Discussion (Misc queries) 1 May 11th 05 08:42 PM
how do i view all groups under excel in google groups JulieD Excel Discussion (Misc queries) 2 December 16th 04 04:33 PM
Iterating Thru Cells Kelvin Clayson Excel Programming 6 November 9th 04 06:33 PM
Iterating through cells problem heenchi[_2_] Excel Programming 1 June 9th 04 11:54 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"