How to remove duplicate items from the Combobox

[kerznerk]

Hello!
I've tied to look for a solution or formula to my problem but none seems to work.
I have made a userform that searches and displays scores of my students. I have made it to work when it comes to displaying the scores of a particular student. The student's name can be chosen from the combobox. My problem however is that it displays name duplicates. The names of students are taken from a sheet in my excel workbook. There really are duplicates of names in the sheet but they vary according to the month and scores.

Here is my code below of the userform

Please Login or Register  to view this content.

Legends:
combobox name = name1
sheet name = Toeic Test Result

Learning VBA is both interesting and challenging. I hope you guys can help me with this.
Thanks

[Miroslav R.]

Hi there,

For case like this, I use application.match = matching the student name in sudent names column. If match value = row number You are on, then add, else skip.

Please Login or Register  to view this content.

Not tested, but should work.

[kerznerk]

Thanks! Ill try this one.