+ Reply to Thread
Results 1 to 4 of 4

TextBox Listbox Filter Down Search Does Not Work

  1. #1
    Forum Contributor
    Join Date
    08-04-2018
    Location
    San Dieg CA
    MS-Off Ver
    Microsoft Office Professional Plus 2016 (Excel 2016 MSO 32 bit)
    Posts
    167

    TextBox Listbox Filter Down Search Does Not Work

    Hello Everyone,
    I hope someone can please help me out with this as I cannot figure it out myself. The below code is supposed to filter down the data in the listbox (listbox1) as the user types in the textbox (textbox10), and produce one or all that matches the key words. However, I cannot seem to get it to work and all I get is error after error. The file is attached and as always, I really appreciate all the help this forum has given me thus far. Thank you in advance for any assistance.

    RB

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: TextBox Listbox Filter Down Search Does Not Work

    Remove the RowSource from your Listbox and add this to your UserForm_Initialize- event

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    08-04-2018
    Location
    San Dieg CA
    MS-Off Ver
    Microsoft Office Professional Plus 2016 (Excel 2016 MSO 32 bit)
    Posts
    167

    Re: TextBox Listbox Filter Down Search Does Not Work

    Hey bakerman2,

    it's good to hear from you. unfortunately, that didn't fix the problem. not only did it not work, also by doing that my other functions on the userform, such edit, delete and so on don't work when I add that piece of code. there are other code tied to the RowSource. is there another way to do and keep the other codes in tact?

    v/RB

  4. #4
    Forum Contributor
    Join Date
    08-04-2018
    Location
    San Dieg CA
    MS-Off Ver
    Microsoft Office Professional Plus 2016 (Excel 2016 MSO 32 bit)
    Posts
    167

    Re: TextBox Listbox Filter Down Search Does Not Work

    Bakerman2,

    Just a quick update, i was able to get the code to work as wall the others functions on the userform, such as edit, delete and so on. i simply added the piece of code to my delete and edit button, removed RowSource as you suggested and it worked just fine. thanks again for the support.

    v/

    RB
    Last edited by RoroBear; 08-11-2019 at 09:46 PM.

+ 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. Search files on Listbox with a Textbox
    By yinkajewole in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-03-2019, 02:46 PM
  2. Filter listbox by value in textbox on userform
    By rgwood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2018, 03:45 PM
  3. Filter listbox with rowsource using Textbox
    By m0nk3yzaii in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2018, 08:38 PM
  4. Search listbox from textbox
    By zplugger in forum Excel General
    Replies: 12
    Last Post: 08-23-2012, 08:11 PM
  5. [SOLVED] Textbox to search listbox
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2012, 08:25 AM
  6. textbox validation in exit does not work with listbox
    By apaknia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 09:17 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