Results 1 to 9 of 9

Search/Filter from multiple combobox to a listbox

Threaded View

Judith_Chao Search/Filter from multiple... 01-09-2017, 05:03 PM
mehmetcik Re: Search/Filter from... 01-09-2017, 07:29 PM
Judith_Chao Re: Search/Filter from... 01-10-2017, 03:35 AM
Judith_Chao Re: Search/Filter from... 01-10-2017, 06:51 AM
mehmetcik Re: Search/Filter from... 01-10-2017, 04:32 PM
mehmetcik Re: Search/Filter from... 01-10-2017, 04:44 PM
Judith_Chao Re: Search/Filter from... 01-10-2017, 06:28 PM
Judith_Chao Re: Search/Filter from... 01-12-2017, 05:57 PM
Judith_Chao Re: Search/Filter from... 01-15-2017, 10:47 AM
  1. #1
    Registered User
    Join Date
    01-08-2017
    Location
    Barcelona
    MS-Off Ver
    Office 2019
    Posts
    82

    Search/Filter from multiple combobox to a listbox

    Hi there
    I'm new on this forum and vba and I don't speak English as well as I must but I hope you can understand my question. It's a boss asking and I must figured out how to solve.*

    At the Model file I have two pages:
    1. Call "Data" in which I have a database stored onto a Table (call Table1") with 11 columns*
    2. Call "Lists" when I store de list and name range I use

    Also I created a userform to search into the database with 5 combo box (the last with a default value).* The values of combo 2 depends on combo1 select and also for the combo 4 to combo 3.* Also I charged the database into the listbox called Results. The data from the combos are, in order the 5 first columns.*

    I try to obtain:
    - Filter / search the result on the listbox when you assign values at the para of combos *
    - Using horizontal name range to populate combos 2 and 4 (it show me only the first value so I must select vertically cells).*
    - Disable the combos 2 and 4 while you don't get a value at combo 1 (for combo 2) or 3 (for combo 4)
    - Show only the columns 6 to 11 from Table1 at the listbox

    I go thriough a lot of model codes from web by because I don't understand it all of it I can't addapted or know where the error is. I'm learning but I must to do this work for this week and I can't reach it in a week alone by now.

    I upload an example file with this parameters if that helps.

    Any help or reference or explanation will be appreciated*
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter UserForm Multicolumn ListBox with TextBox/ComboBox
    By Alex.riccio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2016, 04:31 PM
  2. Checkbox, optionbutton or combobox to filter listbox
    By Claude hauptfleisch in forum Excel General
    Replies: 1
    Last Post: 10-25-2016, 04:51 AM
  3. Using ComboBox on Userform to filter ListBox
    By burger160 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2014, 05:03 PM
  4. [SOLVED] Filter a listbox with a combobox and seach button
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2014, 03:37 AM
  5. combobox and listbox search engine
    By darkhangelsk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 09:47 AM
  6. Search Data using Combobox Textbox and Listbox
    By Adrastia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2012, 05:27 AM
  7. Combobox-listbox multi-type search
    By greekboyuk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2011, 03:47 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