Userform cannot display info for two surnames that is the same from dropdownlist

I using this code to get data from dropdown list

But if I have two surnames that is the same, I cannot get it to show the correct data from each same surname, it show the first name of the first person of the first same surname.

So if say if the first same surname is Pienaar with two names (Piet and Sannie) and second same surname with two names (Jaapie and Sarie, so when I choose any same surname it show 3 names showing (Piet, Sannie and Jaapie).
only happening with same surname. It must show only the name or names of each same surname.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

In your previous thread, you said this:

Thank you, will look at this

That was your last post - you never came back and said whether or not you'd made it work. Members put a lot of effort into helping you, so you should make an effort to ensure that you keep them fully informed. Just marking the thread as SOLVED is not really enough from the point of view of courtesy.

Your code does not take into account that the VAN only appears on the FIRST line so with multiple children it skips all but the first (in column D).

Hence for Pienaar you will select Louis and Michelle and omit Mari.

As John Topley has pointed out - with missing data you will miss out those with blank fields - you need to re-structure your data so that blank surnames are filled.
I have attached a sample - note the last two rows have common surname with differing first names - if you pick search on surname a single choice is available in combobox - however choosing this will give you both entry choices in the listbox.

Thank you , will look and see if this will work for me, will let you know.

Looking at this, it is more difficult that I know, I am not that good in excel vb yet.

Wil take me a while to try to understand what the code is doing so I can use it

My apologises - I attached the wrong app - although very similar the more useful is attached.
Also attached a PDF of the code - this format is easier to follow as it shows the structure (loops etc).
I leave all the controls (textboxes,labels,comboboxes) with their default names - you can loop through them with 3 or 4 rows of code rather then individually naming and reference each which saves many rows of code in a large app.

Does this work for you?
I added a hidden combobox for the ID of the surnames.