Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    checkbox formula (2000)

    Hello,

    I was wondering if there is a way to have a formula or if statement for a checkbox. Basically, I want the user to only be able to select one box (see attached spreadsheet) at a time. The user can get the option of selecting one but not the other. Any help would be great.

  2. #2
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: checkbox formula (2000)

    without having looked at the spreadsheet, why not use radio buttons in lieu of checkboxes.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: checkbox formula (2000)

    You could use option buttons (radio buttons) instead of check boxes. This is more in line with general use in Windows - check boxes are for mutually independent choices, and option buttons for mutually exclusive choices.

    A group of radio buttons shares the same linked cell; the value of this cell will be the index of the selected radio button - 1 if the first one is selected, 2 if the second one is selected, etc. You can use this index in your formula.

  4. #4
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: checkbox formula (2000)

    Thank you both notbrl and Hans. This is exactly what I need it to use instead of the check boxes.

Posting Permissions

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