Results 1 to 7 of 7

Hide/Show rows based on drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    20

    Hide/Show rows based on drop down list

    First of all THANK you to all of you!! You have helped me many times throughout the years and just want to say Thanks!! Now my problem. Have been seaching here and the web and cant get much to work at what Im doing. I have tried Form Control and Active X Drop downs and Combo Boxes and cant get anything to work.

    What Im trying to do is if something is selected from the drop down it would then hide Rows 20:26 but if any other name is selected I would like it to unhide those rows 20:26. I have tried multiple VBA and can never get it to unhide or change with the drop down I always have to enter the number in the cell myself and the vba's work. I have attached an example.

    Using Excel 2010
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide rows based on drop down list
    By soco3594 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2017, 09:08 PM
  2. Hide rows based on muti cell drop down list
    By prat33 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-06-2017, 09:32 PM
  3. Macro to hide/show rows based on Drop Down selection
    By Bleucherie in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-03-2015, 06:14 PM
  4. [SOLVED] Show/hide rows based on drop down cell using named ranges
    By Stu091074 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2014, 11:00 AM
  5. [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
  6. [SOLVED] Macro Filter to hide rows based on Drop Down List
    By dieseldogpi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2012, 11:19 AM
  7. Hide Rows based on Client Drop Down List
    By troyhalsey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2012, 07:28 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