+ Reply to Thread
Results 1 to 4 of 4

Hide Activex Checkboxes with hidden rows.

  1. #1
    Registered User
    Join Date
    02-12-2020
    Location
    ohio
    MS-Off Ver
    10
    Posts
    5

    Question Hide Activex Checkboxes with hidden rows.

    Hello,

    I am making a document that when a activex checkbox is checked(true) then it will reveal hidden rows beneath that have activex checkboxes that will also reveal hidden rows when checked(true). My difficulty is having the activex checkboxes dissappear and reappear with their intended rows. As you can see from the attached photo, my checkboxes appear in the wrong area. Is there a way to lock the checkboxes into a cell or just a way to make them hidden when a checkbox unchecked(false). I know some coding but do not know syntax of VBA and the capabilities. Essentially the below code shows a brief glimpse of what I am trying to do.

    Rows 18:19 ,22 rely on the "Yes" checkbox of row 17.
    Rows 20:21 rely on row 19 "Yes" checkbox.
    Rows 23:24 rely on row 22 "Yes" checkbox.

    Please Login or Register  to view this content.
    Any help would be greatly appreciated. Thank you!
    Attached Images Attached Images
    Last edited by Pepe Le Mokko; 02-12-2020 at 12:52 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Hide Activex Checkboxes with hidden rows.

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  3. #3
    Registered User
    Join Date
    02-12-2020
    Location
    ohio
    MS-Off Ver
    10
    Posts
    5

    Re: Hide Activex Checkboxes with hidden rows.

    Thank you very much. I will be sure to read and abide by those rules. Thanks again!

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Hide Activex Checkboxes with hidden rows.

    Hi riedyp,

    My difficulty is having the activex checkboxes dissappear and reappear with their intended rows.
    What you are seeing is a symptom typical of 'Active X' controls in Excel Worksheets. Welcome to the wacky world of Excel vs. ActiveX.

    There is no easy solution to your problem, as all solutions require a good deal of work. Solutions include:
    a. Deleting all 'Active X' when you open the Workbook, and recreate the 'Active X' using VBA.
    b. Using Forms Controls instead of 'Active X' controls.
    c. Using a UserForm instead of 'Active X' controls.
    d. Create Pseudo CheckBoxes using Shapes.
    e. Use Cells as CheckBoxes using 'Marlett Font'. See http://www.excelforum.com/excel-gene...ml#post4192981

    Good luck.

    Lewis

+ 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. Hide multiple ActiveX checkboxes with name as variable when a cell is returning blank
    By cristihendrix in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-20-2017, 08:59 AM
  3. [SOLVED] My ActiveX Checkboxes won't hide when the row is hidden
    By Angelammarten in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-20-2014, 05:42 PM
  4. Hide multiple checkboxes when a row is hidden
    By daniva92 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-11-2013, 10:20 AM
  5. Hide a many checkboxes when the column is hidden
    By Gruberj01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2013, 06:15 AM
  6. Hiding rows, but checkboxes aren't hidden
    By kid_epicurus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2012, 02:46 PM
  7. excel 2010 activex controls disappear in hidden rows
    By mardyl in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-28-2012, 09:38 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