Results 1 to 1 of 1

Using a listbox to display search results in a userform.

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    Hyderabad
    MS-Off Ver
    2016
    Posts
    15

    Using a listbox to display search results in a userform.

    Hey guys!
    I've been working on this project(attaching it) for a few days now.
    I've recently added a listbox and a search button in my userform. I want the listbox to display entries I have previously made when I enter something in the search box.

    eg. If you open my attachement you can see I have a couple of entries already.
    now when i open my userform and search for Hydrebad, I want the listbox to display all the entries that have Hydrebad in it with all the details right from Coloumn A to Coloumn O
    I want the search box to be flexible enough to display results if I enter any one of the following
    1. City
    2. Customer Name
    3. Customer Number
    3. Brand of cement using
    4. Date of entry

    login id and pass for the userform is
    id :- admin
    pass :- saibabu

    Thankyou for any help you put forward!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search and display results in userform Issue. Results are incorrect
    By olypro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2019, 10:16 AM
  2. Search through database, display results in listbox and copy selected
    By draki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2016, 10:02 AM
  3. Userform:Search through all ws / show results in Listbox
    By wali in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-22-2015, 09:56 PM
  4. Replies: 4
    Last Post: 12-29-2014, 02:46 PM
  5. [SOLVED] Search and display results to listbox
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2014, 05:05 AM
  6. [SOLVED] Userform Search to return results in columns in listbox
    By goffa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 09:53 PM
  7. Textbox search and display results in listbox
    By AirBrun in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-02-2012, 01:22 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