+ Reply to Thread
Results 1 to 2 of 2

clear all checkboxes where values equal FALSE unless a checkbox is chosen

  1. #1
    Registered User
    Join Date
    01-19-2012
    Location
    carmel, in
    MS-Off Ver
    Excel 2003
    Posts
    1

    clear all checkboxes where values equal FALSE unless a checkbox is chosen

    your amendment did allow me to uncheck both boxes, however it disabled the ability of one box to switch the other box's condition.



    [QUOTE=xladept]Maybe:

    Please Login or Register  to view this content.




    [QUOTE=analystspec4]XLA,

    Hi, in april of 2013 your resolved a challenge a for a member: the issue was clicking on one checkbox and therefore unchecking another checkbox. you resolved the issue. Here is the code you provided in the previous post:

    Private Sub CheckBox1_Click()
    Range("R223") = CheckBox1.Value
    CheckBox2 = Not CheckBox1
    End Sub

    Private Sub CheckBox2_Click()
    Range("R226") = CheckBox2.Value
    CheckBox1 = Not CheckBox2
    End Sub

    This worked perfectly for me.

    What I'm hoping you may resolve for me:

    Can you modify the code so that when I uncheck the first box the second box isn't automatically changed to TRUE until the user checks the box.

    currently:

    A. Beginning with both boxes unchecked
    1. check box 1 --> check box 2 remains FALSE (this is agreeable)
    2. check box 2 --> check box 1 switches to FALSE
    3. uncheck box 2 --> check box 1 switches to TRUE

    I cannot have both boxes remain FALSE currently. The reason I need this condition is that the checkboxes are making particular data visible I would like the ability to have both boxes to remain at FALSE so all data can be "hidden" (by conditional formatting) until one or the other boxes is checked.
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: clear all checkboxes where values equal FALSE unless a checkbox is chosen

    Hi Spec4,

    Where the flip are the checkboxes?

    I'll have to look at this tomorrow
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Using ActiveX CheckBox Control to make a cell change colour and clear values
    By drmit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2012, 04:18 AM
  2. Listbox click in search won't populate previously chosen checkboxes
    By Kristengeyer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2011, 04:18 PM
  3. Replies: 7
    Last Post: 05-11-2011, 12:36 PM
  4. [SOLVED] Macro to make all checkboxes false and clear all comboxes
    By ynissel in forum Excel General
    Replies: 5
    Last Post: 07-29-2005, 08:05 PM
  5. [SOLVED] Clear All Checkboxes?
    By Brad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2005, 04:06 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