+ Reply to Thread
Results 1 to 2 of 2

Hide/Unhide cells based on drop-down list

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Adelaide
    MS-Off Ver
    2010
    Posts
    2

    Hide/Unhide cells based on drop-down list

    Hi there,

    I'm super new to VBA, but I've got a problem and I believe this is the right place to ask...

    Here's an example of what I'm trying to achieve...

    Category 1 Category 2 Category 3 Category 4 Drop down menu 1 Drop down menu 2
    Sample Location 1 5 4 1 6 Category 1 Category 1
    Sample Location 2 2 7 9 1 Category 2 Category 2
    Sample Location 3 1 3 5 2 Category 3 Category 3
    Sample Location 3 6 1 2 5 Category 4 Category 4

    What I'm looking to achieve is to have all Categories hidden, and as you select a category from a dropdown list, it appears, and subsequently disappears if you select a different category from the dropdown list. For example - If you select Category 1 (Cells H5:M5, for all sample locations) in Drop down menu 1 and Category 4 (Cells T5:Z5, for all sample locations) in Drop down menu 2, then have all other categories hidden.

    Is this achievable using VBA?

    Any direction would be greatly appreciated.

    Alex

  2. #2
    Registered User
    Join Date
    08-08-2014
    Location
    Adelaide
    MS-Off Ver
    2010
    Posts
    2

    Re: Hide/Unhide cells based on drop-down list

    It didn't format the way I wanted it to, but I hope you get the gist!

    Cheers

+ 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-Unhide rows on multiple worksheets based on value of a drop down list
    By clo2peter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-10-2014, 08:32 AM
  2. [SOLVED] Hide/Unhide columns in multiple worksheets based on item chosen in a drop down list.
    By Gattaca2014 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-27-2014, 01:31 PM
  3. [SOLVED] hide or unhide rows based on text within a drop down list
    By souimet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2013, 01:32 AM
  4. Unhide or hide sheets based on drop down list value - need help combining these two macros
    By kstrick99999 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2012, 06:07 PM
  5. Hide/unhide columns based on the drop down list value
    By vagif in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2012, 02:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1