+ Reply to Thread
Results 1 to 3 of 3

Activating/deactivating one group of checkboxes when another is selected?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    579

    Activating/deactivating one group of checkboxes when another is selected?

    I have two groups of checkboxes. When a box is selected in one, I want it to set all in the other group to false. I have named the groups two different names, for all that helps! Seems that this might be inherent somehow either in the group names or with frames, but I have not seen it. Before I try to chisel out a way to do this through a bunch of code I thought it best to see if this has already been done or is native in some format or means.

    Thoughts?

    Thank-you much!

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Activating/deactivating one group of checkboxes when another is selected?

    Would using optionbuttons work?
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    579

    Re: Activating/deactivating one group of checkboxes when another is selected?

    Not in their traditional implementation as I have used them; I want to be able to select any combination of one to all in a group at any time. I might be able to use option buttons to "activate" a group, but I suspect I could use pretty much anything to do that and be back to where I started, considering a routine to shut all buttons in the "other" group off whenever one was selected in the opposite group...

    Thanks for the thought though!

+ 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. [SOLVED] How to choose a group of checkboxes?
    By Silverado83 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-20-2013, 02:43 PM
  2. How to choose a group of checkboxes?
    By Silverado83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 05:35 PM
  3. activating cell based on option selected
    By vandanavai in forum Excel General
    Replies: 1
    Last Post: 08-12-2007, 07:59 AM
  4. Looping through a group of checkboxes
    By asdfasdf in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-12-2005, 10:05 PM
  5. How to select checkBoxes as a group in
    By Fendic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2005, 10:05 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