Results 1 to 6 of 6

Filter Listbox Values based on Textbox input

Threaded View

redocs Filter Listbox Values based... 07-17-2013, 03:23 AM
Kyle123 Re: Filter Listbox Values... 07-17-2013, 04:25 AM
Kyle123 Re: Filter Listbox Values... 07-17-2013, 04:31 AM
redocs Re: Filter Listbox Values... 07-17-2013, 04:49 AM
Kyle123 Re: Filter Listbox Values... 07-17-2013, 04:51 AM
redocs Re: Filter Listbox Values... 07-17-2013, 04:59 AM
  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Den Haag, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    25

    Filter Listbox Values based on Textbox input

    Hi!

    This will be my first question on this forum. Looking forward to the responses.
    I'm facing some problems with a small project i'm working on, see the attached sample file.

    I need to search all fields in a table named 'Contact' using textbox input.
    This search should real-time filter items in a lisbox on the same userform.

    I've googled a lot and found some examples, but it did not quite match the results i need.
    I need to be able to type whatever info in the textbox and it should find and show the matching names in the listbox.
    So for example i should be able to type a phone number, e-mail, name, etc and it would show the matching names

    I got part of it working for a simple textbox result using the FIND method. Now i need help to translate that to the listbox.

    I hope it makes sense!
    Attached Files Attached Files
    Last edited by redocs; 07-17-2013 at 04:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. [SOLVED] populate userform listbox from textbox input
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 10:05 AM
  3. VBA listbox based on value in textbox
    By excelvraag in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2012, 11:11 AM
  4. combining listbox values to a textbox
    By st0kvis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2011, 06:55 AM
  5. update data based on listbox & textbox
    By SarahPintal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2010, 02:37 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