+ Reply to Thread
Results 1 to 6 of 6

How to lock down other Form Control Checkboxes when one has been selected?

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Talking How to lock down other Form Control Checkboxes when one has been selected?

    See formula below -

    X TRUE =IF(N108=TRUE,90,0)
    FALSE =IF(N109=TRUE,120,0)
    FALSE =IF(N110=TRUE,180,0)

    =SUM(P108:P110)

    If more than one statement is selected as true, then I get an erroneous sum. Is it possible to lock the other check boxes down?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to lock down other Form Control Checkboxes when one has been selected?

    Welcome to the Forum!

    You can do that with VBA code but that's not really what you want to do.

    What you really want to do is use Option Buttons instead of check boxes. Only one option button in a group can be selected at once.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-23-2012
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Arrow Re: How to lock down other Form Control Checkboxes when one has been selected?

    So the Option Button is exactly what I want. However, I've hit yet another brick wall with it. Once the option button has been chosen - I want the preselected amount to flow to another cell - however, this cell should report whichever Option Button has been selected. I can't figure it out! I've attached the worksheet - I appreciate your help!
    Attached Files Attached Files

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to lock down other Form Control Checkboxes when one has been selected?

    What is the "preselected amount"? Is this the numbers next to each option button?
    Which cell do you want the preselected amount to flow to? Is it E8?
    What do you mean by "report whichever option button has been selected"? E2 does that.

    Just looking at your sheet doesn't tell me how you intend to use it or what you want it to look like. It looks like it works fine to me. I am guessing that what you want to is very simple to implement in Excel but first I have to understand it in English

    The only thing I could recommend would be getting rid of all the formulas in F2:F6 and putting this formula in E8:

    =CHOOSE(E2,90,120,120,120,180)

  5. #5
    Registered User
    Join Date
    11-23-2012
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to lock down other Form Control Checkboxes when one has been selected?

    The Choose function worked beautifully!! THANK YOU!!

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to lock down other Form Control Checkboxes when one has been selected?

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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