+ Reply to Thread
Results 1 to 2 of 2

Hide / Unhide rows based on contents of cells VBA

  1. 05-15-2016, 10:30 PM #1
    holli
    holli is offline
    Registered User
    Join Date
    05-11-2015
    Location
    melbourne
    MS-Off Ver
    2010
    Posts
    38

    Hide / Unhide rows based on contents of cells VBA

    I would like to hide rows in Sheet 1 depending on text in cells A15-A18.

    A number is picked from a dropdown box in cell D13. This triggers certain role descriptions to appear on cells A15:A18.

    Rows 22-24 will be hidden and I want them to only be unhidden if the corresponding role description appears in cells A15:A18

    e.g. If Team leader appears in in cells A15:A18 I would like row 22 to be unhidden

    I have attached a test spreadsheet to try and explain my problem better.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-16-2016, 03:24 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Hide / Unhide rows based on contents of cells VBA

    Hi,

    One way

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    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. Need Toggle Button to hide/unhide rows based on cell value in non concurrent rows
    By The Phoenix in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-13-2015, 10:49 AM
  2. [SOLVED] Hide/unhide Cell contents based on checkbox
    By Kelton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2014, 04:25 PM
  3. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  4. Hide/Unhide rows based on Cell Value
    By noelwri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 04:25 PM
  5. Hide/Unhide Rows in One Worksheet Based on Values in Cells in Another Worksheet
    By xponent_es in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2011, 03:26 PM
  6. Hide/Unhide Rows based on Zero Value
    By chiz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2010, 05:28 AM
  7. Hide/Unhide rows based on 3 cells values
    By bimmer5dude in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-24-2008, 11:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1