+ Reply to Thread
Results 1 to 5 of 5

ComboBox VBA to Hide/Show Rows

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    10

    ComboBox VBA to Hide/Show Rows

    Hey guys, I have several ComboBox with two options, yes and no.

    The idea that when you select "yes", row "x" will be displayed, and when you choose "no" row "x" will be hidden.

    I'm new to VBA and have no idea how to do this.

    Any help will be greatly appreciated!

  2. #2
    Registered User
    Join Date
    06-23-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    10

    Re: ComboBox VBA to Hide/Show Rows

    bump............

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: ComboBox VBA to Hide/Show Rows

    something like this one
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  4. #4
    Registered User
    Join Date
    06-23-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    10

    Re: ComboBox VBA to Hide/Show Rows

    Thank you, that works like a charm!

    I have one question though, how do I go about assigning multiple functions to the same Combo Box? I ask this because this same Box that hides the row visibility also controls sheet visibility.

    I tried to use End Sub and start another Private Sub with the same Box name, but then I get an " Ambiguous Name" error.

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: ComboBox VBA to Hide/Show Rows

    just set to visible true/false a sheet?! when would you wanna be set to visible true/false?
    an option is below
    Please Login or Register  to view this content.

+ 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 Selected Rows that does not contain Values from combobox
    By chubbyjenz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2015, 09:10 AM
  2. [SOLVED] Hide rows depending on combobox result
    By jimemonge in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2013, 11:11 AM
  3. [SOLVED] VBA Userform with ComboBox to Hide/Unhide Rows
    By leecook in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-01-2013, 03:50 AM
  4. Hide Rows Dependant on Combobox Value
    By shudder in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2012, 08:55 AM
  5. Hide and unhide rows based on combobox
    By pkling in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2010, 03:25 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