+ Reply to Thread
Results 1 to 2 of 2

filter data using comboboxes and display in listbox

  1. #1
    Registered User
    Join Date
    01-26-2017
    Location
    IRELAND
    MS-Off Ver
    2016
    Posts
    17

    filter data using comboboxes and display in listbox

    Hi, I have data in worksheet that I want to filter by comboboxes.
    Combobox3 = product
    Combobox4 = Requester initial
    Combobox5 = Tool status

    My code now can filter the data when each combobox is selected and applied individually.
    but i want to have to code to filter the data base on all three of two combox values.

    I also want to display the filtered data in worksheet ‘Filtered data view’ in the list box.

    I have tried various code, but still could not get it working.
    Thank you in advance for your help.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: filter data using comboboxes and display in listbox

    Quote Originally Posted by reiiling View Post
    ...but i want to have to code to filter the data base on all three of two combox values.
    I don't know what that means

    If you want to filter for multiple criteria in multiple fields, store the values for each combobox...
    Please Login or Register  to view this content.

    Then filter each field...
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. 3 Dynamic ComboBoxes to filter data and populate a ListBox
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-05-2018, 05:26 AM
  2. Problem with display textbox when filter the data in listbox
    By lacromo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2015, 08:28 AM
  3. [SOLVED] Problem with display information when filter the data in listbox
    By lacromo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2015, 10:55 PM
  4. [SOLVED] Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a userform
    By p_nayak268 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-27-2014, 12:41 PM
  5. VBA userform listbox populate data entered from comboboxes
    By Hilton1982 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2012, 11:29 PM
  6. Listbox filter and display issues
    By brouhaha501 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-14-2010, 08:10 AM
  7. Listbox filter and display issues
    By brouhaha501 in forum Excel General
    Replies: 1
    Last Post: 06-07-2010, 03:57 PM

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