+ Reply to Thread
Results 1 to 3 of 3

Help with Radio Button or Checkbox

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Kohler, WI
    MS-Off Ver
    2007
    Posts
    12

    Help with Radio Button or Checkbox

    I have this Excel spreadsheet that I was able to get to work the way I want to with Checkboxes, however, now I am thinking I would really like it to only allow the user to click one box/button per row. The way I created it, it allows the user to check multiple boxes in each row.

    QUESTION
    How can I can keep the formula's/results but make it so the user can only click one option per row.
    Can only click in cell D9 or F9 or H9 or J9 or L9., but not more than one in that row.

    Repeat the process in rows 10 through 17
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,601

    Re: Help with Radio Button or Checkbox

    Use ActiveX Optionbuttons. Use the same linked cell as the checkboxes; but, select the five buttons in each row, then in the Properties dialog, give them a group name. For instance, those in row 9 would use FinancialHealth.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-16-2014
    Location
    Kohler, WI
    MS-Off Ver
    2007
    Posts
    12

    Re: Help with Radio Button or Checkbox

    Excellent.. I will attempt to do the other rows. Thanks you so much for your assistance.

+ 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. Display 1 or 0 based on Checkbox selection - On Radio Button Click
    By gmalpani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2014, 05:37 AM
  2. Replies: 0
    Last Post: 06-10-2014, 10:44 PM
  3. [SOLVED] Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database
    By christlivethinme in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2013, 02:24 PM
  4. Pressing one radio button to select another radio button
    By raehippychick in forum Excel General
    Replies: 1
    Last Post: 09-13-2007, 11:30 PM
  5. checkbox / radio button or combo-box???
    By ko6ad in forum Excel General
    Replies: 1
    Last Post: 02-11-2006, 10:40 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