Results 1 to 17 of 17

Checkboxes - How to check/uncheck other checkboxes based on another checkbox

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    South Dakota, USA
    MS-Off Ver
    2016
    Posts
    14

    Checkboxes - How to check/uncheck other checkboxes based on another checkbox

    I don't have much experience/knowledge of macros, but I'm sure there's got to one out there that can do what I have in mind. Workbook with example is attached.

    I have 3 main scenarios that a customer could choose. Based on what scenario they choose, there are certain products that come automatically with that scenario.

    I would like someone to be able to:
    1. (COMPLETE) Check a box to select which scenario they want (I have checkboxes already set up in Row 2 that do this part)
    2. Once a scenario is selected, the other 2 scenarios cannot be selected at the same time (i.e. only scenario 1, 2, OR 3 can be checked, you can't check scenario 1 AND 2...)
    3. Once a scenario is selected, the appropriate product checkboxes automatically check and product checkboxes for the other scenarios get unchecked (i.e. if I chose scenario 1, the appropriate products under scenario 1 would get checked but all products under scenarios 2 and 3 would get unchecked)
    4. Keep the ability to check and uncheck manually (i.e. certain products come standard with scenario 1, but you have the option to check/uncheck a product to add/remove it ad-hoc)

    The way the spreadsheet is set up now shows which products should be included in each scenario. I just can't get the macro to automate what I laid out above.

    Thank you so much!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] check and uncheck certain checkboxes with a button
    By 2mi3 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-29-2015, 03:55 PM
  2. Macro to automatically check or uncheck checkboxes based on a linked cell
    By lmshow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 03:31 AM
  3. [SOLVED] multiple checkboxes macro check/uncheck
    By SHELTONUNDERDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2012, 01:36 PM
  4. How to check and uncheck a column of checkboxes with 1 checkbox?
    By kteo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2012, 08:42 PM
  5. Forms Check/Uncheck CheckBoxes
    By Kaziglu Bey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2008, 03:04 PM
  6. Check/Uncheck all checkboxes
    By JChandler22 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2007, 03:03 PM
  7. Replies: 5
    Last Post: 01-04-2006, 07:15 PM

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