+ Reply to Thread
Results 1 to 10 of 10

Search and display results in list view

  1. #1
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Search and display results in list view

    Hi everyone,

    Is it possible to display the multiple results in list view?

    I have text box in user form and a search button. And i have a list view in which the results will be displayed.

    Column B is my reference for the search area. I want to display all possible results in list view.

    For example:
    > I want to search for tax number but since i have 10 type of tax, then Tax 1 to Tax 10 will be displayed in the list view.
    > Or if i want to search for sales only then sales group, sales are, sales office will display in the list view.

    Is this possible?
    Would appreciate if someone can really help me
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Search and display results in list view

    under command button
    use
    Please Login or Register  to view this content.
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

  3. #3
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Search and display results in list view

    under command button
    use
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: Search and display results in list view

    Hi Kamboj,

    Thanks for your reply! Just want to ask how can i declare the worksheet name since i have many sheets?

  5. #5
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Search and display results in list view

    Please Login or Register  to view this content.

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Search and display results in list view

    See if something like this works for you...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  7. #7
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: Search and display results in list view

    Wow Sktneer! Thats awesome! Btw, how can i remove the number and should only show the data from column B??

    Also, once i double click the data in listview, how can i call another code that i have??

    Thanks in advance!
    Last edited by geliedee; 01-19-2016 at 08:15 AM.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Search and display results in list view

    Try this...

    Please Login or Register  to view this content.
    And to call another Code when you double click a list item, try this...
    Please Login or Register  to view this content.
    Replace the red line as per your requirement.
    Attached Files Attached Files

  9. #9
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: Search and display results in list view

    Wow! Sktneer! That's what exactly i need. I already pasted my code and it worked fine
    Last edited by geliedee; 01-20-2016 at 05:26 AM.

  10. #10
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Search and display results in list view

    You're welcome. Glad I could help.
    And thanks for the feedback as well.

+ 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. CRM Search Box & Display Results
    By JamesHansford in forum Excel General
    Replies: 1
    Last Post: 10-07-2014, 08:40 AM
  2. [SOLVED] Display search results inluding results that match patrially
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 08:52 AM
  3. Search and Display only Search Results
    By Atalanta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2011, 10:43 AM
  4. List Search Time & Then List Next Search Results on Next Available Line
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2009, 09:39 AM
  5. Search List and display results
    By morjo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2008, 02:32 AM
  6. [SOLVED] How can I view multiple search results?
    By Judy F in forum Excel General
    Replies: 2
    Last Post: 01-27-2006, 12:20 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