+ Reply to Thread
Results 1 to 3 of 3

Option Buttons use for Yes/No questions on a worksheet not able to select more than one

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2010
    Posts
    24

    Option Buttons use for Yes/No questions on a worksheet not able to select more than one

    I have a worksheet with questions and I have to create options of yes and no and n/a with radio buttons for each question.
    I have created the buttons and the groups for each question but only one button can be selected at a time on the entire worksheet.
    So when I answer the second question the selection for the first question clears.
    I have been researching this for 2 days now and I am not having any luck. I am not skilled at coding can someone please help me?
    I am attaching a blank version of the questionaire.


    ULDD BUTTONS.xlsx

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Option Buttons use for Yes/No questions on a worksheet not able to select more than on

    Why aren't the macros in the workbook? I see no code in the VBA viewer.

    So it's kinda hard to say what the issue is because it looks like all of your radio buttons are trying to trigger the same OptionButton2_Click sub.

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Option Buttons use for Yes/No questions on a worksheet not able to select more than on

    I didn't write any VBA code. I don't know how really. I don't know what you mean. I am completely lost here.

+ 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. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  2. [SOLVED] How to reset all option buttons on a given worksheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2012, 03:19 PM
  3. Copy worksheet and keep option buttons operable
    By Jerums in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-09-2012, 08:08 PM
  4. Two Groups of Option Buttons on Worksheet
    By Jim May in forum Excel General
    Replies: 0
    Last Post: 06-24-2006, 04:40 PM
  5. [SOLVED] Option buttons on a worksheet
    By Ann Shaw in forum Excel General
    Replies: 1
    Last Post: 04-27-2005, 10:06 AM

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