+ Reply to Thread
Results 1 to 6 of 6

Hide Unhide Rows using Checkbox

  1. 07-25-2014, 04:17 PM #1
    Huskersippi
    Huskersippi is offline
    Registered User
    Join Date
    11-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Hide Unhide Rows using Checkbox

    Excel Checkbox.jpg

    I'm trying to Hide and Unhide entire rows based on checkbox. I have my macro which calls on two other macros and it works fine but I would like to have a checkbox for each individual row (150 total). Is there a way to create multiple checkboxes and change the macro so it references the row that the checkbox resides in or do I have to create a macro for each individual row ... Surely Not ..... Thanks in advance

    Sub Checkbox()
    If Range("A2").Value = "True" Then
    Call Hide
    ElseIf Range("A2").Value = "False" Then
    Call Unhide
    Else

    Return
    End If

    End Sub
    Reply With QuoteRegister To Reply
  2. 07-25-2014, 04:51 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Hide Unhide Rows using Checkbox

    Hi Huskersippi

    See this linkhttp://www.bettersolutions.com/excel...A619860332.htm
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 07-25-2014, 04:59 PM #3
    Huskersippi
    Huskersippi is offline
    Registered User
    Join Date
    11-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Hide Unhide Rows using Checkbox

    Beautiful! Exactly what I needed ...... TY
    Reply With QuoteRegister To Reply
  4. 07-25-2014, 05:24 PM #4
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Hide Unhide Rows using Checkbox

    You're welcome...glad I could help. Thanks for the Rep.

    I've used that referenced Code (modified) several times...works well...
    Reply With QuoteRegister To Reply
  5. 07-28-2014, 03:33 PM #5
    Huskersippi
    Huskersippi is offline
    Registered User
    Join Date
    11-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Hide Unhide Rows using Checkbox

    Here is my file. Thank you so much for taking the extra time to help with this

    Jeremy
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-28-2014, 05:08 PM #6
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Hide Unhide Rows using Checkbox

    Hi Jeremy

    Play with the Code in the attached. There are four Macros in the Workbook and the Workbook uses Non ActiveX Checkboxes.

    Sub DeleteCheckBox() and Sub addCBX() are setup routines that will add Checkboxes and assign Code to them for what ever Range you define in the Code.

    The other routines, Sub HideRow() hides the Row on which the Checkbox is located and Sub UncheckAll() makes all Rows visible and unchecks all Checkboxes.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Checkbox to hide and unhide rows
    By xjenniex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2014, 04:42 PM
  2. [SOLVED] hide and unhide rows in different worksheet using a checkbox
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2014, 10:20 AM
  3. Macro to hide/unhide rows using checkbox
    By jdp554 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-23-2011, 11:57 AM
  4. hide/unhide rows using checkbox
    By elfirahayu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2010, 03:31 PM
  5. Hide / unhide rows with help of a checkbox
    By Hansa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2009, 12:56 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1