Userform Find and Replace

I have attached my spreadsheet. What I am trying to do is to be able to search for data on the Data worksheet (to get to the user form I click the modify referral on the out worksheet). The code I have so far works but when I search for records that have duplicate "cmm" values it only fills in the first 10 fields on the form with the appropriate info. For example in the attached file if you click on the CMM text box and type in 6262 then find it comes up with 2 instances of 6262. but when you click on each individual record in the list box only the 1st 10 textboxes change with the appropriate info.

Any Ideas why this is happening?

Here is my code for the userform.

Please Login or Register  to view this content.

But when I put in more then that I get an error. I will goback and do that then post the error

So when I add this code I get a runtime error -2147024809 (80070057)
Could not get the List Propert. Invalid Argument

.TextBox11.Value = ListBox1.List(r, 10)

Highlighted in yellow

Please Login or Register  to view this content.

When I enter in your code I get a Run time error 13
Type mismatch when I go to select the 2nd instance of 6262 with a yellow hightlight on the follow row.

Please Login or Register  to view this content.

You are Awsome. So how then do I fix the last and first commands to load the next record. For example when I click the arrows it will scrool though the data to the next record or previous record

Let me first thank you for all your help and time. I am still having problems with the first and last buttons. when I click on them it is not scrolling to the next record just showing the same record 6262 which is neither the forst or last record so i am not sure how that is happening. Could it have somethign to do with thelist box. In your previous thread you hade the following code for the first button as

Please Login or Register  to view this content.

but that will only display one particular row so I changed it to below but it still does not work correctly

Please Login or Register  to view this content.