+ Reply to Thread
Results 1 to 3 of 3

VBA userform, filter a two column listbox value as the user type in the textbox

  1. #1
    Registered User
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    68

    VBA userform, filter a two column listbox value as the user type in the textbox

    This is a similar problem which I have posted before in this link,
    but in a different condition.

    I have a UserForm Listbox which has two columns,
    one for the name of the customer and one for purchased total price.
    The ListBox is populated from a "temporer" pivot table, so the code is like this :

    Please Login or Register  to view this content.
    What I want now is to searh the ListNama item by adding a TextBox.
    The code for the TextBox that I got from AlphaFrog before (in the other thread) is:

    Please Login or Register  to view this content.
    I've tried to change the blue code to like this:
    Please Login or Register  to view this content.
    But it doesn't work.

    How do I modified the TextBox1 code above as my situation now :
    1. There is no named range
    2. the ListBox has two columns

    Any kind of respond would be greatly appreciated.
    Thank you in advanced.

    Addition:
    Just now I'm trying to make the code for the TextBox something like this :

    Please Login or Register  to view this content.
    (The bold codes is the additional ones)
    It doesn't work with a purple lines.
    If I delete the purple line, it works but now the TextBox only has one column, the name only.
    Last edited by karmapala; 02-12-2019 at 02:29 PM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,786

    Re: VBA userform, filter a two column listbox value as the user type in the textbox

    Have a look here: https://www.excelforum.com/tips-and-...e-listbox.html

  3. #3
    Registered User
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: VBA userform, filter a two column listbox value as the user type in the textbox

    Thank you Kyle123.
    I will look over it and try to implement it to my need.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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