+ Reply to Thread
Results 1 to 2 of 2

Filter UserForm Multicolumn ListBox with TextBox/ComboBox

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Ottawa
    MS-Off Ver
    Excel 2010
    Posts
    7

    Filter UserForm Multicolumn ListBox with TextBox/ComboBox

    Hi Everyone,

    I've been looking for an answer to this specific scenario and I haven't found it yet. If it exists, I'm sorry for wasting your time and would request the link to that answer please.

    If not, here we go.

    I'm creating a listbox in a userform that's using a rowsource from a sheet to list the multicolumn list.

    This list is very big and I want to be able to filter through it using a combobox to specify which column to filter by and a textbox to specify the keywords to filter by.

    I've found different iterations of these in pieces but not as a whole and I haven't been able to put it together.

    Here is the code I have so far:

    Please Login or Register  to view this content.
    I get a "Unspecified Error" (80004005) When I get to the ".RemoveItem i" line which I've read is because I'm using RowSource to populate the list.

    Is there an easier what to achieve all this?

    Thank you for your help and let me know if you need more information.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Filter UserForm Multicolumn ListBox with TextBox/ComboBox

    I never use Rowsource.

    replace

    Please Login or Register  to view this content.
    With

    Please Login or Register  to view this content.


    You might like to see my list Userform.

    Borrow the bits you like.

    Come back with questions.
    Attached Files Attached Files
    Last edited by mehmetcik; 12-07-2016 at 07:13 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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] Sort for multicolumn listbox in userform (5-columns)
    By d.sanchez in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-11-2017, 05:30 AM
  2. Replies: 0
    Last Post: 08-18-2015, 04:13 PM
  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. Loading MultiColumn Combobox in a Userform
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2014, 10:47 AM
  5. [SOLVED] excel vba filter values to listbox from combobox and save edit values in textbox
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 08:42 AM

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