+ Reply to Thread
Results 1 to 3 of 3

Dependent checkboxes where only one can be checked at a time.

  1. #1
    Registered User
    Join Date
    01-06-2016
    Location
    NYC
    MS-Off Ver
    2010
    Posts
    2

    Dependent checkboxes where only one can be checked at a time.

    Hi All,

    I know this topic has been posted elsewhere and I've tried a few of the solutions, but none have worked the way I'd prefer. I know I can use option buttons, but (1) I like the way the checkboxes look better and (2) I have dependent checkboxes on multiple sheets (haven't attempted to use option buttons for this). I'm using 20 checkboxes in total at the moment that I want to be dependent. The current Macro I'm using says:
    If CB1 is true then
    make all others false
    else
    if CB2 is true
    make the others false
    else
    and so on.

    This works well if you check CB1 first, then check CB2 next. It will then uncheck CB1. But, if you check CB2 first, it will not let you check CB1. Instead, you have to uncheck CB2, then check CB1. This does work, but is a little clumsy.

    Hope some of you guys (or gals?) can help.

    Thanks!
    Last edited by dabrams83; 01-22-2016 at 11:08 AM.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Dependent checkboxes where only one can be checked at a time.

    Have you tried something like
    Please Login or Register  to view this content.
    and did not worked ?
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Registered User
    Join Date
    01-06-2016
    Location
    NYC
    MS-Off Ver
    2010
    Posts
    2

    Re: Dependent checkboxes where only one can be checked at a time.

    that actually worked great. i've never used active x controls before, and that was the missing ingredient. thanks.
    Last edited by dabrams83; 01-22-2016 at 11:08 AM.

+ 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. Copy rows if checkboxes are checked
    By KT99 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2014, 03:14 PM
  2. Summing checked checkboxes
    By bermudamohawk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2014, 11:25 AM
  3. How to copy only checked checkboxes into new cell?
    By GTX2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2013, 09:06 PM
  4. Checkboxes checked based on cell value
    By humboldtguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-23-2010, 09:48 AM
  5. Replies: 1
    Last Post: 09-21-2008, 01:36 PM
  6. [SOLVED] My checkboxes will not stay checked.
    By NUMBnut in forum Excel General
    Replies: 0
    Last Post: 01-09-2006, 05:10 PM
  7. Assessing whether any checkboxes are checked within frame
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2005, 05:05 PM

Tags for this Thread

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