+ Reply to Thread
Results 1 to 4 of 4

VBA Hide/Unhide row in work sheet if value in column H = "Y" w/ a toggle button

  1. #1
    Registered User
    Join Date
    11-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    VBA Hide/Unhide row in work sheet if value in column H = "Y" w/ a toggle button

    This is my first dabble at VBA, i can usually find what i need by searching it on line but i need some help on this one;

    i need a toggle button to hide the entire row if the value in column H is equal to "Y".

    Thanks,

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: VBA Hide/Unhide row in work sheet if value in column H = "Y" w/ a toggle button

    so you'd like to create a togglebutton that hides/unhides EVERY row in column "H" that is equal to "Y"? Or just one specific row?

    Please Login or Register  to view this content.
    Here's an attempt to do it with a static Range. If the range shall be dynamic, you can change the looping function a bit.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Registered User
    Join Date
    11-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: VBA Hide/Unhide row in work sheet if value in column H = "Y" w/ a toggle button

    Thanks B,

    It is doing exactly what I wanted it to do. Awesome!

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: VBA Hide/Unhide row in work sheet if value in column H = "Y" w/ a toggle button

    Hello ywang,

    Welcome to the Forum.

    If you are satisfied with the replies to your Thread, then please do mark your Thread as Solved.

    Thank you,

    Regards
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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. [SOLVED] Click "-" or "+" to hide and unhide rows
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2013, 08:03 AM
  2. Replies: 1
    Last Post: 09-21-2013, 03:18 AM
  3. button to toggle hide/unhide columns
    By dbuff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2013, 07:56 PM
  4. Using Toggle Button to hide/unhide rows that may change
    By jmpatrick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 09:48 AM
  5. How to HIDE/UNHIDE Specific Sheets Using a TOGGLE Button?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2011, 02:58 AM

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