Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2008
    Location
    Albuquerque, New Mexico, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have 6 checkboxes in Excel 2003. You can see them in the attachment on row 29. I want to be able to check a box and have that number show up in the cell M29. I tried the radio buttons but the next radio button that I added linked to the previous buttons and I cannot get them to unlink, therefore I thought I would try check boxes. However, is there code that can force only one check box to be checked at a time? Can the number appear in cell M 29 based on the checked box?
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    I don't think there's a way to get the checkboxes to be mutually exclusive without VBA code; that's not really what they're inherently for (while that is what the option buttons are for).

    To get the option buttons to be exclusive within a group, it looks like you need to put each related group of option buttons inside a Group Box, like you have for the first three sets of option buttons.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Why are you using check boxes? You've already been told in the Excel forum that you need to use radio buttons aka option buttons.

Posting Permissions

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