See John Walkenbach's page on this topic:

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

--
Regards,
Tom Ogilvy


"Chinx21" wrote:

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.