+ Reply to Thread
Results 1 to 5 of 5

How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2002
    Posts
    10

    How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?

    I am using Excel 2010. Whenever I try to insert multiple sets of option buttons, they are all placed in the same set (such that when I click an option button in one set, it undoes an option button in the other sets). I have tried changing the reference cell of the option buttons, but whenever I do the reference cells for the entire worksheet are changed along with it. I think this can be resolved using multiple Group Boxes but I need to do this without using group boxes due to space limitations on my worksheet.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?

    That's why they're called Option buttons - You only have one of a series of options.
    Checkboxes allow for multiple selections
    Elegant Simplicity............. Not Always

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?

    If you using a Userform you can use a "Frame" control to divide them. In a sheet use a "Group Box" and "Form" Controls.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?

    Use ActiveX option buttons and you can use their GroupName property to group specific buttons.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    11-11-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2002
    Posts
    10

    Re: How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?

    Thank you for the replies. I'll try the Active X suggestion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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