Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Checkbox results test (Excel 97 SR2)

    I have a user that put a checkbox (Check Box 9) on a worksheet. They want cell G2 (on same sheet) to display the words 'Final Claim' if the checkbox is checked and if it is unchecked G2 should display the words 'Partial Payment'.
    I do not remember how to change the contents of the cell based on the results of the checkbox (Or how to test for the contents of the checkbox).
    I believe the checkbox was from the forms toolbar.
    Really hopes the search engine will come back soon.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

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

    Re: Checkbox results test (Excel 97 SR2)

    You must link the check box to a cell.

    If you created the check box using the Forms toolbar, right click the check box and select Format Control. In the Control tab, set the linked cell.
    If you created the check box using the Control Toolbox, right click the check box and select Properties. Set the LinkedCell property.

    In both cases, the linked cell will be TRUE if the check box is checked, FALSE if it is cleared. Say that the linked cell is G1 (it can be in a hidden column or row if you prefer). The formula in G2 becomes

    =IF(G1,"Final Claim","Partial Payment")

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Checkbox results test (Excel 97 SR2)

    right click on the cekcbox (I assume it is FORMS) format control - control tab - cell link [select a cell (eg A1)]

    If the checkbox is from control toolbox right click - properties Put A1 (or whatever) in the "LinkedCell" property

    Then when you check the box A1 = TRUE when unchecked it is FALSE

    In G2 enter:
    =if(A1, "Final Claim","Partial Payment")

    Change A1 to whatever is appropriate.


    Steve

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks Hans and Steve

    Hans & Steve,
    Thanks! It worked like a charm.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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