Duplicate row source of combobox (code pls.)
 

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.

Duplicate row source of combobox (code pls.)
 

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.