+ Reply to Thread
Results 1 to 4 of 4

Multiple checkboxes to tick 1 checkbox

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    4

    Multiple checkboxes to tick 1 checkbox

    Hello all,
    please help me on this:

    I have 4 checkboxes: a, b, c, and d.
    if all three check box a,b, and c is checked, then check box d is checked.
    if any of a, b, or c is unchecked, then check box d is unchecked.

    I've been struggling with this but can't figure out.
    please help.

    Thanks,

    TD
    Last edited by tUyET dEn; 02-21-2009 at 04:08 AM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Multiple checkboxes to tick 1 checkbox

    Hi, and welcome to the forum. Not sure if this is what you're after, but give it a try. From your explanation, the user cannot select checkbox D all by itself (since it cannot be checked if A, B or C aren't checked, and it must be checked if all three are checked).

    The code below pertains to four checkboxes named CheckBox1 thru CheckBox4 on a worksheet using the Controls Toolbox objects, not those from the Forms toolbar. The code is the same for each checkbox.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-20-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Multiple checkboxes to tick 1 checkbox

    wow
    amazing.
    You're are so fast and so right-to-the-answer

    I had this in mind, but it never come to works. It kept saying Then , Goto after my IF statement.

    anyways, it works now.

    Thanks for your codes!!!
    I truly appreciate it!!

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Multiple checkboxes to tick 1 checkbox

    Glad I could help!

    If you feel the issue is resolved, please mark your thread as solved by clicking the Edit button in the first post in this thread, and in the Edit Post section click the Prefix drop-down box and choose 'Solved'. Re-submit it and your thread will be marked solved!

    Thanks!

+ 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