How to populate multiple column listbox with unique combinations only

Hello

I am a VB noob and i am trying to help my non-tech savvy colleagues in a rural non-profit to maintain better data.

I am sure there are better ways of data maintenance, but they are used to one way of working over the years and I need to align the excel to match their way of doing things.

They maintain user data with static details (like name, village, occupation, etc.) and dynamic details (service taken, etc.) in the same sheet. Problem is, due to manual entry, the static fields become erroneous.

So what I want to achieve in the userform is:
1. If he is new user, he signs up separately.
2. If old user, he chooses his name in a dropdown list.
3. User details (static ones) are shown in a listbox. Since there are multiple people with exactly the same name, he chooses which details match him.
4. These details are passed on to the form and he adds the dynamic details.

I have done everything, the only two areas where I am blocked are:
1. How to lookup the values in the excel and display in a multi-column textbox ONLY with the unique combinations. Presently, i am populating a list, but its showing all values and also, i cannot use that for point 2 below. I need a better way.
2. How to carryover the values to the other userform from the list box (I think I will be able to figure this point out myself if the first problem is resolved)

I am attaching the sheet with some dummy values for your reference.

Would it be possible to help? Let me know if I have not been able to convey the issue clearly.

Copy of Data tool.zipCopy of Data tool.zip

hi shuvajit, welcome to Excelforum, re 1 problem area:
1. How to lookup ...
Check attachment.
I have made some changes to Initializing code as well.

Hello

Thanks for the help... The files work just as i want them to ...

I am going by Leith's file, because it seems, having the values as separate columns will allow me to carry over the values to the next sheet easily.

Thanks a lot again.