+ Reply to Thread
Results 1 to 6 of 6

[Solved] Checkboxes not working once visible

  1. #1
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    9

    Question [Solved] Checkboxes not working once visible

    So i have this code, its supposed to show/hide rows when checkbox9 (yes) is checked

    Please Login or Register  to view this content.
    It works fine but acts strange when it's trying to show/hide checkbox11 and 12.
    1. Checkbox11 is hidden but checkbox 12 is visible
    2. Once cb11 and 12 are shown they won't be clickable anymore. it just shows a doubled image of itself
    afterimage.PNG

    My question is how to hide and show rows and checkboxes if a master checkbox is click (for example if I click yes then more rows will show with their respective checkboxes)

    Please and thank you in advance
    Last edited by jester113; 06-11-2021 at 12:03 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: Checkboxes not working once visible

    The issues of hiding rows vs. hiding checkboxes is getting muddled here. We can't tell where your checkboxes are just by looking at this image, and we don't know the properties of your checkboxes.

    We can help better if you attach your file (see yellow banner at the top of the page).
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    9

    Re: Checkboxes not working once visible

    Hi Jeff
    Thank you for the help and swift response. Please see the attached sheet. it has minimal coding, but it shows the issues off the bat.

    edit: Don't know what happened when you first open the sheet, the 2 set of checkboxes are on top of each other and you need to move them off each other
    Attached Files Attached Files
    Last edited by jester113; 06-10-2021 at 05:24 PM.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: Checkboxes not working once visible

    I did not experience the problem you described. Everything worked fine. Do you have other code in your actual sheet, such as Worksheet_Change?

    I do have a suggestion: Since user responses are mutually exclusive I recommend option buttons instead of checkboxes. I have attached the modification to your example. I did see a problem when I did this a little bit like what you described. When I clicked on Yes a phantom copy of the button showed up lower down while I held down the mouse button, and I could not change the state of the button. I hit DELETE in the B4 and that seemed to clear it up. I was not able to find the cause.

    I also had the same problem you did with one button overlaying another. I set the buttons to "Don't move or size with cells" and that seemed to solve it. Again, I don't know the cause.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    9

    Re: Checkboxes not working once visible

    THis is great! Thank you so much for the fast reply i really appreciate this!

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: [Solved] Checkboxes not working once visible

    The way we mark a thread solved is below, rather than editing the title:

    Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved...

+ 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. Are Checkboxes visible/usable to people without developer activated
    By Frandz in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-23-2020, 09:49 AM
  2. [SOLVED] Checkboxes not working
    By Crawl in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2020, 12:57 PM
  3. [SOLVED] Multiple Checkboxes Visible or Not Visible
    By janicesm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2014, 05:37 PM
  4. [SOLVED] Making checkboxes not visible
    By Elizabethd1012 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-01-2014, 02:27 PM
  5. How can I select only the visible checkboxes only one column?
    By kikisell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2013, 02:20 PM
  6. Macro with checkboxes - not working
    By kaligad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 06:23 AM
  7. hidding rows with checkboxes and coping visible rows to another sheet
    By aviflux in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2008, 09:35 AM

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