+ Reply to Thread
Results 1 to 8 of 8

Filter choice selection based on combobox values

  1. 09-11-2017, 01:51 AM #1
    ocgMax
    ocgMax is offline
    Registered User
    Join Date
    09-11-2017
    Location
    Bristol
    MS-Off Ver
    2013
    Posts
    4

    Unhappy Filter choice selection based on combobox values

    SDCAT.PNG SCAT.PNG

    Hi, im trying to get the value from the combo box to filter the data in sheets as i dont use userform. but the combobox value cant be detected. i didnt know if i dont declared it as string or because of the value inside the combo box is too long. i used 2 code to add value in combo box (array & manually add . additem). When the user select the value inside combo box the ACO category will automatically filter to the selection only. 

    Please Login or Register  to view this content.
    im try both ways to add but the array is looping the data inside the combo box and the manual additem is error.
    Reply With QuoteRegister To Reply
  2. 09-11-2017, 02:43 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter choice selection based on combobox values

    Hi ocgMax

    Welcome to the Forum!!!

    Pictures are of little value.

    Please attach a sample workbook the Structure of which is the same as your actual workbook.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

    Remember to desensitize the data.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit .
    John

    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.
    Reply With QuoteRegister To Reply
  3. 09-11-2017, 10:21 PM #3
    ocgMax
    ocgMax is offline
    Registered User
    Join Date
    09-11-2017
    Location
    Bristol
    MS-Off Ver
    2013
    Posts
    4

    Re: Filter choice selection based on combobox values

    Hi jaslake,

    right now my problem is how to filter the data according to value inside the combo box.

    Please Login or Register  to view this content.
    cbo_cat = Combo Box name

    category = value inside the Combo box

    A - Administration
    B - Finance
    C - Specialist
    D - Industrial
    E - Professional
    F - Technical
    G - ICT Network & Equipment
    H - ICT Management Implementation & Support
    I - Applications, Databases & Systems
    J - Transport
    K - Education
    L - Other
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-11-2017, 10:39 PM #4
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter choice selection based on combobox values

    Hi ocgMax

    What version of Excel are you using? Your Profile indicates Excel 2013 yet you've uploaded an .xls File.
    Reply With QuoteRegister To Reply
  5. 09-11-2017, 11:27 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter choice selection based on combobox values

    Hi ocgMax

    Your cbo_cat_Change() Code filters on the wrong Column and Row...try changing it to this...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 09-12-2017, 12:06 AM #6
    ocgMax
    ocgMax is offline
    Registered User
    Join Date
    09-11-2017
    Location
    Bristol
    MS-Off Ver
    2013
    Posts
    4

    Re: Filter choice selection based on combobox values

    my excel is 2013. it works

    can u help me

    If the filter have category all and all is set as default. Which mean if user didnt select anything from combo box it will automatically go for "ALL". How to set "All" as default.
    Reply With QuoteRegister To Reply
  7. 09-12-2017, 01:40 AM #7
    ocgMax
    ocgMax is offline
    Registered User
    Join Date
    09-11-2017
    Location
    Bristol
    MS-Off Ver
    2013
    Posts
    4

    Re: Filter choice selection based on combobox values

    ' set for default

    cbo_cat.ListIndex = -1
    Reply With QuoteRegister To Reply
  8. 09-12-2017, 11:15 AM #8
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter choice selection based on combobox values

    Hi ocgMax

    I'm not sure what you're looking for here...

    If the filter have category all and all is set as default. Which mean if user didnt select anything from combo box it will automatically go for "ALL". How to set "All" as default.
    See if this does as you require...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] ComboBox to populate Listbox and 2nd Combobox based on 1st combobox dropdown choice
    By bbqqsmokeman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2017, 08:21 PM
  2. [SOLVED] Filter worksheet based on last word of combobox selection
    By DanielZig in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-03-2016, 09:29 AM
  3. Updating Text Box with Cell Values based on ComboBox Selection
    By Huskersippi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2016, 02:19 AM
  4. ComboBox values source being changed based on another combobox selection in a UserForm
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2016, 11:12 PM
  5. filter and copy filtered data to another sheet based on combobox selection
    By prince82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2015, 11:09 PM
  6. [SOLVED] Textbox - populate with month name and values based on Combobox selection
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2015, 08:09 AM
  7. Excel VBA - Hide cell values based on ComboBox selection
    By jpergega in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2015, 12:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1