+ Reply to Thread
Results 1 to 4 of 4

Using Checkboxes to control other sets of checkboxes

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    TX, USA
    MS-Off Ver
    2013
    Posts
    69

    Using Checkboxes to control other sets of checkboxes

    Column A is a set of one type of rule conditions 16 rows $A$2:$A$17
    Column D is another $D$2:$D$14
    And so on.

    My objective is to have a "Select all" checkbox that checks only the appropriate groups of cells, and un-checks the others for specific configurations.
    I also have a checkbox that I need to turn invisible when another cell ="", and reappear with it isn't.

    Lastly, I have a column with several cells with 3 radials. I need each cell to produce numbers independently.
    If one equals a cell reference they all equal that cell reference.
    Say $L$2:$L$13

    Example attached. I tried to format for clarity
    Attached Files Attached Files
    Last edited by Entregan; 11-13-2018 at 12:26 PM. Reason: Attaching File

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Using Checkboxes to control other sets of checkboxes

    Hello Entregan,

    Cold you please attach a sample workbook (not a picture or pasted copy).
    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    01-28-2015
    Location
    TX, USA
    MS-Off Ver
    2013
    Posts
    69

    Re: Using Checkboxes to control other sets of checkboxes

    I attached a sample file to the opening post. Thank you.

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Using Checkboxes to control other sets of checkboxes

    Hello Entregan,

    Your sample Workbook contains formulae extending beyond the range/s in you sample, returning #Ref Errors. I would therefore not be able to assist with your issue. It is also not clear to me exactly what your requirement/s is/are. You have a lot of Check Boxes and Option Buttons, and I cannot figure out how you want them to interact.

    Maybe someone else on this Forum might be able to assist you further. Sorry about that.

    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. hiding rows which contain checkboxes but checkboxes don't hide as they should
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-08-2019, 10:26 AM
  2. [SOLVED] Checkboxes - How to check/uncheck other checkboxes based on another checkbox
    By brooklyn_87 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-27-2017, 01:20 PM
  3. [SOLVED] Toggle between userform checkboxes for multiple pairs of checkboxes
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-25-2016, 06:31 AM
  4. Control if all checkboxes are FALSE (then...)
    By menielsen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2016, 08:20 AM
  5. master checkboxes to select a group of other checkboxes?
    By fael097 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-26-2016, 03:46 PM
  6. Replies: 4
    Last Post: 04-28-2013, 12:47 AM
  7. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM

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