+ Reply to Thread
Results 1 to 4 of 4

Search through data and display

Hybrid View

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    United States
    MS-Off Ver
    2007
    Posts
    1

    Search through data and display

    Hi,

    I am new to this forum, and I have a question. I'm decent in Excel, but far from coding pro. I just recently switched my Microsoft Works database over to Excel format. Easy enough, but I don't have the same searching capabilities as I did in the works database. I have 14 columns, and I am currently on line 15,115. Yeah, a crap ton. I need to be able to search and have the results displayed together in the table so I can see all of the information on all of the results right there together. I'm not sure if this is what is referred to as "userform" or not. I would be very appreciative if someone could help me with this.

    Thanks!
    Candice

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Search through data and display

    You need to use my three textbox search Userform.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Search through data and display

    You need to use my three textbox search Userform.

    I will simplify it and post a copy for you

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Search through data and display

    Ok.

    This is just to demonstrate the search capability of my userform.

    The List box can be made to be multi column.

    It can even be made to be multi select

    And we can do anything we want with the selected data.

    I await your virdict.
    Attached Files Attached Files

+ 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] Search Part of Data and display entyre row data in another sheet
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2014, 01:36 PM
  2. Help: Search data in worksheet and display the data in userform text boxes
    By RAB7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 05:37 AM
  3. Search Box to Search and Display Data
    By kimhan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-16-2013, 08:11 PM
  4. [SOLVED] Macro to search for and display data in another worksheet
    By Mark H in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Macro to search for and display data in another worksheet
    By Mark H in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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