+ Reply to Thread
Results 1 to 2 of 2

UserForm to search a list and display results

  1. #1
    Registered User
    Join Date
    09-24-2018
    Location
    Munich, Germany
    MS-Off Ver
    2013
    Posts
    1

    Question UserForm to search a list and display results

    Hi Guys,

    im pretty new to excel and want to build my first vba code, though I struggle greatly. Any help is very appreciated!

    Following Problem: I have a datalist of 3000 rows and 50 colums and I want to build a seperate Userform, that searches this list for 2 criteria and displays the relevant rows/results. The criteria are "Source" in Row 18 and "Aim" in row 19.
    So the input of the user in the userform are these two terms. Then the tool should display the results, I'm not quite sure how yet. At best, it even filters the results for only a couple of colums and so reduces the output data to only 3,4 cells.

    If you need further information, let me know.

    Thank you very much everyone!!
    Kealy

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: UserForm to search a list and display results

    Example, Is this what you looking for?
    See attached
    If you post a small example of your datalist (5 rows or so) then I can make an example of a userform.
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

+ 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. Replies: 1
    Last Post: 12-14-2015, 07:10 PM
  2. [SOLVED] userform. search and display results from that row
    By SPARKY347 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2015, 07:40 AM
  3. Search through database and display results in userform
    By karthikcoep in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-24-2012, 05:08 AM
  4. Replies: 15
    Last Post: 02-07-2012, 11:39 AM
  5. Re: Search through database and display results in userform
    By sacarnold in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2011, 01:37 AM
  6. Search through database and display results in userform
    By postmatt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-31-2011, 10:04 AM
  7. trying to use VBA to concatenate and display search results on a userform
    By Case45 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2009, 09:46 AM

Tags for this Thread

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