+ Reply to Thread
Results 1 to 2 of 2

Hide Rows based off items from a ComboBox List.

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    Longview, Texas
    MS-Off Ver
    2003
    Posts
    15

    Hide Rows based off items from a ComboBox List.

    I have 2 Combo box's sitting side by side, based off the list I need rows hidden and shown, so that the proper questions are shown. This is repeated down the sheet.

    This is the code I was using when I was using Data Validation, however since I need the arrow on the right hand side to always show I switched to Combo box's.
    Any help would be greatly appreciated.

    Thank you in advance for any help.


    This is the code I was using when I was using Data Validation, however since I need the arrow on the right hand side to always show I switched to Combo box's.
    Any help would be greatly appreciated.

    Please Login or Register  to view this content.
    Ok here is the code for what I currently have but Combox.1 cancels out Combobox.2 I cannot figure out how to put these two together.
    Please Login or Register  to view this content.
    I have also tried asking this question on another forum
    http://www.mrexcel.com/forum/excel-q...ml#post3967404
    Attached Files Attached Files
    Last edited by Glitch_; 10-17-2014 at 09:28 AM. Reason: I have also tried asking this question on another forum

  2. #2
    Registered User
    Join Date
    10-09-2014
    Location
    Longview, Texas
    MS-Off Ver
    2003
    Posts
    15

    Re: Hide Rows based off items from a ComboBox List.

    Found the solution my using a series of true or false functions to decide weather the list box is true and then using the if function to create a number based of what the selection is. looks like this.


    Awning FALSE 1 TRUE 1
    Parallelagrams FALSE 4 FALSE 4
    Marketing_Case FALSE 4 FALSE 4
    Select TRUE 4 FALSE 0


    Then put this in sheet one.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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] Hide rows and columns based on a combobox value
    By yasirmusa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-23-2012, 04:52 PM
  2. [SOLVED] How VB code can unhide/hide rows based on combobox selection?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2012, 01:25 PM
  3. Add combobox to a Word doc and populate the combobox with list of about 65 items
    By excelaron in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2012, 01:59 PM
  4. 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
  5. How do I refer to the items in a combobox by their number in the list of items?
    By lottesfog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2007, 10:03 PM

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