+ Reply to Thread
Results 1 to 3 of 3

conditional checkbox insertion

  1. #1
    Registered User
    Join Date
    04-30-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    32

    conditional checkbox insertion

    I have a checkbox at the top which totally alters which form appears below. But either possible form also has checkboxes that pertain specifically to that form. I cant make the checkboxes appear and/or dissapear depending on the condition of the "master checkbox" at the top. any ideas?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: conditional checkbox insertion

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    04-30-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: conditional checkbox insertion

    cant figure out how to do that but here's a mock"
    "boxa" Check to see form1
    "boxb" check to see form2
    ___________________________________________________
    "FORM1"(Same page just entirely different layout, text, formulas, etc...)

    "box1a" = check to enable option x on this form(form1, not visible on form2).
    _____(box1a is only visible IF boxa is checked )_______________________________________
    "FORM2"(Same page just entirely different layout, text, formulas, etc...)

    "box2a"= check to enable option y on this form(form2, not visible on form1).
    (box2a is only visible if boxb is checked)
    All text on the form, i used IF statements to decide what text is displayed. i have successfully programmed the entire page to be switched back and forth based on box a, and b, except for the boxes 1a, and 2a. they remain visible on either form, and thats not what i want. i need to be able to code box1a, and 2a with something like: =if(boxa=TRUE, show box 1a, dont show box1a)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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