+ 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
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    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
    365 Win 11
    Posts
    7,238

    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
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    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)

Similar Threads

  1. [SOLVED] VBA userform, filter listbox value as the user type in the textbox
    By karmapala in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2018, 05:08 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 UserForm Multicolumn ListBox with TextBox/ComboBox
    By Alex.riccio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2016, 03:12 PM
  4. [SOLVED] VBA code to filter listbox as you type in a textbox Solved by : Sixthsense
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2014, 10:51 AM
  5. VBA Code To Filter Listbox As You Type In A Textbox
    By Benjamin2008 in forum Excel General
    Replies: 3
    Last Post: 12-20-2013, 08:57 PM

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