+ Reply to Thread
Results 1 to 3 of 3

Yes or no buttons but not both

  1. #1
    Registered User
    Join Date
    04-03-2022
    Location
    Sulphur, LA USA
    MS-Off Ver
    Office 365
    Posts
    5

    Yes or no buttons but not both

    I have a Google Sheet that has yes or no checkboxes. I want to have the two checkboxes side by side. If the person checks the "yes" checkbox and then presses the "no" button, it will change the opposite checkbox from true to false and vice versa. I know how to use radio buttons in Excel but not in Google Sheets.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Yes or no buttons but not both

    This can be done with Apps Script.....

    Where:
    * Column A is the Question column
    * Column B is Yes
    * Column C is No
    * There is a header row (Question, Yes, No)

    Put checkboxes into cells below the header row in columns B and C.


    Go to the menu: Extensions > Apps Script

    and add this apps script:
    Please Login or Register  to view this content.
    NOTE: due to this type of system being a little slow to respond, i would suggest instead to use a dropdown with your options Yes,No

    BONUS:
    Add a checkbox count into column D, with this formula in D2 and drag down:
    Please Login or Register  to view this content.
    Add an answer column into column E, with this formula in E2 and drag down:
    Please Login or Register  to view this content.
    Last edited by janmorris; 04-04-2022 at 05:34 AM.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Yes or no buttons but not both

    heres an alternative Apps Script that seems to work much faster:

    but again, the Yes and No are in columns B and C (in the script they are columns "2" and "3")

    Please Login or Register  to view this content.

+ 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. Radio Buttons only working on some computers, Buttons are being renamed
    By branas7180 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 12:03 PM
  2. Macros with buttons, spin buttons, scroll buttons, etc.
    By qqbbppdd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 09:34 AM
  3. enable certain combo buttons based on user selected option buttons
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2013, 06:43 AM
  4. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  5. How to insert Buttons, radio buttons and check boxes in Excel
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 08:13 AM
  6. 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
  7. Replies: 2
    Last Post: 07-10-2005, 04:05 PM

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