Combobox data

[Emece]

I have one sheet with a combo box, and one sheet with the
data of this combobox, both in the same workbook.

The values that appear in the sheet that contains the data
can be repeated, but I want the combobox to show them only
once.

I haven't find a propertie to control this.

Any idea?

Thanks.

 

[Dave Peterson]

John Walkenbach has some code to populate a listbox with unique entries. You
could adapt that for your combobox.

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