Duplicate row source of combobox (code pls.)

[Chinx21]

I have a combo box that contains value from a certain column of a worksheet.
That column has duplicate values.example:
Teacher
aa
bb
cc
dd
ee
ff
aa
cc
ee


What i want is for those duplicates not to appear in the combobox list.
Could Anyone help me pls.

 

[Tom Ogilvy]

See John Walkenbach's page on this topic:

http://www.j-walk.com/ss/excel/tips/tip47.htm