+ Reply to Thread
Results 1 to 5 of 5

Hide rows based on cell values

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    Hide rows based on cell values

    Hello,
    VBA novice here, and hopefully someone can help!
    Writing a tax compilation sheet for preparers - users have to fill in Cells A10, B10, and C10 with either "yes" or "no" from a drop-down data validation list.

    If users select "yes" for all 3 cells ---> rows 150 - 200 will be displayed. If any of the cells are "no", then I want the rows 150 - 200 to be hidden.
    I've been successful with the following code for one y/n question, but it won't work for the 3 criteria test:

    Please Login or Register  to view this content.
    Any insight is appreciated, and thanks in advance
    Last edited by DonkeyOte; 06-18-2009 at 05:00 PM. Reason: code tags added (on behalf of OP in lieu of latter post)

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    re: Hide rows based on cell values

    mlb830, welcome to the Board - please take the time to read the forum rules.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

  3. #3
    Registered User
    Join Date
    06-18-2009
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    re: Hide rows based on cell values

    My apologies,
    Code is as follows:

    Please Login or Register  to view this content.
    Thanks!

  4. #4
    Forum Contributor
    Join Date
    01-28-2008
    MS-Off Ver
    Excel 365
    Posts
    157

    re: Hide rows based on cell values

    This works. Convert to lower case in case user enters "Yes":
    Please Login or Register  to view this content.

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Hide rows based on cell values

    Perhaps you mean along the lines of:

    Please Login or Register  to view this content.

+ 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