+ Reply to Thread
Results 1 to 7 of 7

My ActiveX Checkboxes won't hide when the row is hidden

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    12

    My ActiveX Checkboxes won't hide when the row is hidden

    I am creating a worksheet for my employer that has many ActiveX checkboxes that when checked unhide rows which contain text boxes or other checkboxes. My frustration has been that the rows that have additional checkboxes are hiding the row but the checkbox is still visible. I have tried multiple solutions including (but not limited to) selecting the "move but don't size" in format controls, grouping the checkboxes and selecting the "move but don't size" and also tried some code that I had found, to no avail.

    Note: I am fairly new to VBA codes but have been learning quickly so if there are other things wrong with the codes I have written below or if it somehow is affecting the whole functionality of my sheet let me know. Im VERY grateful for the help!!!

    This is the first set of code I used to try and hide the checkboxes:

    Please Login or Register  to view this content.
    And the second:

    Please Login or Register  to view this content.

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

    Re: My ActiveX Checkboxes won't hide when the row is hidden

    Hi Angelammarten and welcome to ExcelForum. Thank you for following the rules by using CODE TAGS. It is much appreciated.

    Your first construction is perfectly valid and works on my computer:
    Please Login or Register  to view this content.
    Your second construction for an 'Active X' Checkbox event handler is incorrect. You will need code similar to the following (tested and working):
    Please Login or Register  to view this content.
    --------------------

    The file associated with post #2 in the following thread may be helpful to you either now or in the future. It creates 'Active X' CheckBoxes and uses one (Class) Event Handler to service all 'Active X' CheckBox change events. http://www.excelforum.com/excel-prog...sition-it.html

    -------------------

    From your second code sample, you may want to view post #2 on the following thread, which discusses the differences between 'Forms' and 'Active X' controls. http://www.excelforum.com/excel-prog...ml#post3880991


    Lewis

  3. #3
    Registered User
    Join Date
    11-06-2014
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    12

    Re: My ActiveX Checkboxes won't hide when the row is hidden

    Lewis thank you for your help, however it still is not working so perhaps there is more info needed.

    The ActiveX checkbox that controls the features is #12

    The rows I want hidden are 110-129

    The ActiveX checkboxes in those rows are numbered 27-45

    There is no linked cell affiliated with Ckbxs 27-45, should there be?

    As always thank you a million for your help!!

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

    Re: My ActiveX Checkboxes won't hide when the row is hidden

    I will try to work on your problem tomorrow.

    Please verify that you have all 'Active X' CheckBoxes.

    When Excel creates an Active X CheckBox it is named 'CheckBox1' etc. (created from the 'Control Toolbox' ToolBar in Excel 2003).

    When Excel creates a 'Forms' CheckBox it inamed 'Check Box 1' etc. with the two spaces (created from the Forms Toolbar in Excel 2003).

    It is OK if you use both types, I just have to know what you have.

    Lewis
    Last edited by LJMetzger; 11-19-2014 at 06:34 PM.

  5. #5
    Registered User
    Join Date
    11-06-2014
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    12

    Re: My ActiveX Checkboxes won't hide when the row is hidden

    Ok Thanks Lewis, I've been stumbling over myself for three weeks tweaking this thing There are Active X controls for cells that are associated to a code. I do have form control c box that are more for informational purposes and have no other action tied to it.

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

    Re: My ActiveX Checkboxes won't hide when the row is hidden

    Hi Angela,

    The ActiveX checkbox that controls the features is #12
    The rows I want hidden are 110-129
    The ActiveX checkboxes in those rows are numbered 27-45
    Try the following code (all checkboxes are 'Active X'):
    Please Login or Register  to view this content.
    --------------------------

    There is no linked cell affiliated with Ckbxs 27-45, should there be?
    There is no need for a 'linked cell' unless you are going to use the value in the 'linked cell' in a workbook formula somewhere.

    I hope this helps. Please let me know if you need any further assistance.

    Lewis

  7. #7
    Registered User
    Join Date
    11-06-2014
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    12

    Re: My ActiveX Checkboxes won't hide when the row is hidden

    Success!!! It worked!! Thank you so much Lewis! You are a god among men.

    I'm sure I will be back

+ 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. 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
  2. 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
  3. [SOLVED] ActiveX control checkbox to (un-)check all checkboxes
    By Stefan1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2012, 07:39 AM
  4. Copy&Pasting OptionButtons and Checkboxes (Normal/ActiveX)
    By enfinity86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2012, 12:56 PM
  5. ActiveX Control Checkboxes and Table Order
    By rubix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2010, 08:39 AM

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