+ Reply to Thread
Results 1 to 3 of 3

VBA code for a search of data and return result to a listbox on userfrom

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    England
    MS-Off Ver
    Excel2007
    Posts
    2

    VBA code for a search of data and return result to a listbox on userfrom

    Hi guys

    I am new to excel VBA and i am wondering if someone could help, i am looking to do a data search of a work sheet that has 8 colums of data and return the result to a userform.

    There is a textbox on the user form where the search data is typed into and this will lookup colum A.

    If any matches are found the data from colums b,c,d,e,f,g and h are displayed in the userform.

    Colum A will contain dates and there may be more than one the same so if there is i would like all the matces to be displayed.

    Many thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: VBA code for a search of data and return result to a listbox on userfrom

    DBase Search.xlsm

    Try that - I think it's what you may be looking for
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    England
    MS-Off Ver
    Excel2007
    Posts
    2

    Re: VBA code for a search of data and return result to a listbox on userfrom

    Thankyou i will try this and alter it where i can

    Many 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. Bold items in Userfrom ListBox
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2013, 03:14 PM
  2. [SOLVED] Populate a Listbox in a UserForm based on a Search Result
    By clapforthewolfman in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-17-2013, 07:53 PM
  3. Search Code vba return to the new sheet with duplicate data
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2013, 06:28 PM
  4. how to use VBA to search and return search result in the user form
    By pearlynie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2013, 07:58 AM
  5. Listbox value return from search
    By Mcat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2005, 06:10 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