Results 1 to 4 of 4

Hide Activex Checkboxes with hidden rows.

Threaded View

  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.

    Private Sub Hide()
    If CheckBox210.Value = True Then 
    [18:19,22:22].EntireRow.Hidden = False
    [20:21,23:24].EntireRow.Hidden = True
    CheckBox213.Hidden = True
    CheckBox214.Hidden = True
    CheckBox215.Hidden = True
    CheckBox216.Hidden = True
    CheckBox217.Hidden = True
    CheckBox218.Hidden = True
    'Else: [18:24].EntireRow.Hidden = True
    CheckBox213.Hidden = True
    CheckBox214.Hidden = True
    CheckBox215.Hidden = True
    CheckBox216.Hidden = True
    CheckBox217.Hidden = True
    CheckBox218.Hidden = True
    'End If
    'End Sub
    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.

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