+ Reply to Thread
Results 1 to 1 of 1

Creating multiple groups of radio buttons

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Creating multiple groups of radio buttons


    I have a spreadsheet which combines tabular data with a complicated graphical output. Due to the unique requirements of this sheet, normal filtering confuses the user, so I'd like to create the filters I want via radio button blocks.

    For example, Block 1 would allow the selection of A1, B1, C1, or D1, Block 2 would allow the selection of A2, B2, C, or D2, etc. In combination, the user can select the combination they want, which would filter the tabular data, thereby generating the desired output

    When I create the option button groups using wither form or Activex controls, I can't get the syetem to reconginze that A1, B1, C1 are in one group and A2, B2, C2 are in a second group.

    Is there a way to create groups of radio buttons?


    Late breaking news -

    I changed my construction sequence and it apparently now works - to wit:

    If I created all my group boxes then added the specific radio buttons to each group, the system believed all radion buttons were linked.

    If I created a group, then added the buttons for that specific group, then created the next group box, it appears to work

    Last edited by c1802362; 10-28-2013 at 10:02 AM. Reason: solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel survey using groups of radio buttons side by side
    By SnoterB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2013, 06:37 PM
  2. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  3. Creating a Survey-Style Form Using Radio Buttons in Cells
    By antiSocialWorker in forum Excel General
    Replies: 1
    Last Post: 04-20-2012, 03:52 PM
  4. Creating radio buttons
    By JamesT1 in forum Excel General
    Replies: 1
    Last Post: 08-28-2008, 02:45 PM
  5. How do you set mutliple groups of radio buttons?
    By dwm in forum Excel General
    Replies: 4
    Last Post: 06-08-2006, 06:10 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1