+ Reply to Thread
Results 1 to 3 of 3

How to hide & unhide rows based on selection from drop down box?

  1. #1
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    How to hide & unhide rows based on selection from drop down box?

    Good moring, I have a worksheet that allows you to choose 1-20... depending on the selection it should unhide specific rows but I keep getting errors... I don't see what the issue is but my eyes are pretty tired.

    Also anyone know the code that will allow you to unhide other worksheets in the same book????
    Attached Files Attached Files
    Last edited by jgomez; 02-01-2013 at 01:16 PM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: How to hide & unhide rows based on selection from drop down box?

    Hi, jgomez,

    although you marked this thread as solved I´d used a Boolean for checking if the event is triggered again (code behind Sheet MstrSheet):
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    AFAIR True in VBA is -1 while in Excel it´s 1.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    Re: How to hide & unhide rows based on selection from drop down box?

    Thank you.

+ 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