+ Reply to Thread
Results 1 to 7 of 7

Please help with this monster! Need help w/VBA codes to hide and unhide rows base on lists

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Please help with this monster! Need help w/VBA codes to hide and unhide rows base on lists

    I need help with this monster please! I know it is a lot but, I am not a programmer and have no idea on how to get this done. Can someone please help me?!?!?! I have attached the spreadsheet... this is what i need help on:

    I want rows 18 thru 62 hidden at first.
    If the answer to Y16 is yes I want rows 18:20 to unhide
    If the answer to Y19 is yes I want rows 21:23 to unhide
    If the answer to Y22 is yes I want rows 24:26 to unhide
    If the answer to Y25 is yes I want rows 27:29 to unhide
    If the answer to Y28 is yes I want rows 30:32 to unhide
    If the answer to Y31 is yes I want rows 33:35 to unhide
    If the answer to Y34 is yes I want rows 36:38 to unhide
    If the answer to Y37 is yes I want rows 39:41 to unhide
    If the answer to Y40 is yes I want rows 42:44 to unhide
    If the answer to Y43 is yes I want rows 45:47 to unhide
    If the answer to Y46 is yes I want rows 48:50 to unhide
    If the answer to Y49 is yes I want rows 51:53 to unhide
    If the answer to Y52 is yes I want rows 54:56 to unhide
    If the answer to Y55 is yes I want rows 57:59 to unhide
    If the answer to Y58 is yes I want rows 60:62 to unhide

    I have this code for Rows 64 Ė 70:

    Please Login or Register  to view this content.
    Row 71 Column 16 I need the same code as above to occur. I tried to add the same code with different row info and it didnít work. This did not work: (I just pasted it below the code above)

    Please Login or Register  to view this content.
    I need the same code once more for rows 111:118 based on T110

    I need for Row 82 to unhide if I81 is Yes
    I need for Row 83 to unhide if Q81 is Yes

    Please help me! Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru 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: Please help with this monster! Need help w/VBA codes to hide and unhide rows base on l

    Hi SeniaHdz

    Welcome to the Forum. Please wrap your Code in Code Tags per the Forum requirements.

    To do so, in your Original Post, highlight your code and click the # icon at the top of your post window.

    You may have ONLY one Worksheet_Change Event for any given Worksheet. You'll need to combine the two you have in order for it to work. Play with this concept...let me know if you need further help.
    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.

  3. #3
    Forum Guru 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: Please help with this monster! Need help w/VBA codes to hide and unhide rows base on l

    Hi SeniaHdz

    Please do the Code Tag thing if you wish further help.

    While your playing with this, try to build on this
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Please help with this monster! Need help w/VBA codes to hide and unhide rows base on l

    This code will do all that you ask. So Enjoy.


    Please Login or Register  to view this content.
    Last edited by mehmetcik; 04-12-2013 at 06:01 PM.

  5. #5
    Registered User
    Join Date
    04-08-2013
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Please help with this monster! Need help w/VBA codes to hide and unhide rows base on l

    Thank you for your help

  6. #6
    Registered User
    Join Date
    04-08-2013
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Please help with this monster! Need help w/VBA codes to hide and unhide rows base on l

    Thank you for your help!

  7. #7
    Forum Guru 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: Please help with this monster! Need help w/VBA codes to hide and unhide rows base on l

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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