Results 1 to 6 of 6

Userform Combobox & Listbox two criteria two different columns search and copy entire row

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Gainsborough, England
    MS-Off Ver
    Office 2016 & Office 365
    Posts
    87

    Userform Combobox & Listbox two criteria two different columns search and copy entire row

    Hi people

    Been a while, Sheet Summary contains a Search button activates a userform in which i have a combobox and a listbox, combobox has a list of names by choosing one it populates the listbox with a list of products, what I want is to click the product in the listbox this will then search a sheet named Log, column "D" contains the names (combobox) and column "G" contains the name of product so when the search matches name and product chosen by combobox and listbox it should copy the entire row to the Summary sheet, there will be multiple instances of the match so the Summary sheet should contain all rows matching combobox and listbox selection, I did try some vba but I could only get it to do one criteria not two, hope I have explained it ok

    Thanks in advance
    John
    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. [SOLVED] ListBox to populate UserForm trouble with same search criteria
    By chriswhite1982 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-10-2014, 01:46 AM
  2. [SOLVED] Changed userform combobox to listbox, unable to get userform to retrieve datasheet values
    By dragonabsurdum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2013, 01:38 PM
  3. [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
  4. search 2 different columns for same information and copy entire row
    By Biogeek1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2013, 08:44 AM
  5. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM

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