Listbox filter and display issues

here is the second part:

Please Login or Register  to view this content.

bump - no response

I apologize if the description above is a bit too much, or may not make sense, so i will attempt to clarify.

I have a worksheet where one person on the list may have multiple rows of data. I am trying to create a userform to first search all claims with ther persons reference number, and display all rows of data in a listbox.

Then, when one of the items in the listbox is clicked, i would like to have multiple textboxes fill with the data from that specific row.

I first attempted used a combobox where you can type in the reference number you were looking for, then it would populate the listbox with the correct results. but, when you clicked on one of the items in the listbox, it would not populate the row that you wanted to see. Instead, it populates the first row of data on the worksheet, and go down from there (i.e 1st, 2nd, 3rd ect).

My second attempt I used RoyUK's example found on http://www.excel-it.com/vba_examples.htm and tried to tweak it to fit this worksheet. It works excellant, with the exception tha the textboxes fill from the listbox, and only 9 columns can go in a listbox. both of the coding is posted higher up on this same thread.

I'm in a VERY bad way right now as I really need to solve this problem soon for work. Any and all help is appreciated more than I can put into words. Please please please, if you could help!!!

I have attached the two different examples.

Thank you so much for helping out!! I'm still having an issue though:

When i type in a reference number into the combobox (userfilter), the listbox shows all of the filtered results of all of the rows with the specified info in it. but when i click on one of the items in the listbox, the textboxes to the right will populate from the first row in the sheet.

For instance - if you type in the reference number 5886410 into the combobox, the listbox will show two dates, one for each row that has the reference number in it. but when you click on the top date (02/02/2010) it will reference the very top row for Brendan Brendan instead of test sixteen, which is who the reference number is for.

I think what's happening is the code for the listbox is pulling from the sheet as a whole instead of pulling the information from that particular row, but i have no clue how to fix it.

Romper, thanks so much again for all of your help. it's really been awesome of you to take a look at this for me, and i do appreciate you taking the time to lock down the coding.

You ARE AWESOME!!!! thanks so much. it does EXACTLY what i need it to do!!!