+ Reply to Thread
Results 1 to 7 of 7

Search data in listbox from table as i type in textbox

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Search data in listbox from table as i type in textbox

    hi,
    i am using below to search data from table 1 and showing in listbox using textbox1 and textbox2 with command button

    Please Login or Register  to view this content.
    but i want to show search result in listbox as i type in textbox1 and textbox2


    thanx a lot
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Search data in listbox from table as i type in textbox

    Put the code for the command button in a new sub in the userform (for example Sub Pop_List, but any name is fine), then make the button code "Call Pop_list", and make change events for textbox1 and textbox2, which also just have the code "Call Pop_List"
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Search data in listbox from table as i type in textbox

    Sorry Arkadi,
    Not able to do what u said?
    Will you plz explain again

  4. #4
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Search data in listbox from table as i type in textbox

    Sorry Arkadi,
    Not able to do what u said?
    Will you plz explain again

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Search data in listbox from table as i type in textbox

    Please note your post says textbox1 and 2, but code has textbox2 and 3

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Search data in listbox from table as i type in textbox

    Thanx Arkadi Sir, for great help
    Will test this one tomorrow morning.

  7. #7
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Search data in listbox from table as i type in textbox

    absulutly perfect

    thanx a lot my dear Arkadi

+ 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] How to filter a table using textbox and show filtered data in listbox (userform)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2017, 10:31 AM
  2. [SOLVED] Search within a ListBox as you type in a TextBox
    By Boechat in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2016, 05:39 PM
  3. [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
  4. 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
  5. Remove items from a listbox as you type in a textbox
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2013, 04:10 PM
  6. Search Data using Combobox Textbox and Listbox
    By Adrastia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2012, 05:27 AM
  7. [SOLVED] Textbox to search listbox
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2012, 08:25 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