ComboBox displays duplicates - please help

[Guest]

Please Help!
In my ComboBox property
I have a ListFillRange 'Input data'!C1 - C200

Column 'C' has duplicate names.
I can't edit or change column 'C'

How do I write code so that it will not display
duplicates when selecting the comboBox.

I think a function like this but not sure how to write it...
in Properties for the combobox.
I would set the following to pass back name in column 'C' but filter out
duplicates.

ListFillRange = NoDuplicates("C1:C200")

Thank you for your help

 

[Dave Peterson]

John Walkenbach shows how to use a collection to get a unique list. He also
shows how that list can be sorted (you may want to do that):
http://j-walk.com/ss/excel/tips/tip47.htm

 

[Guest]

Thank you, it is very helpful.

--
Jeff

John Walkenbach shows how to use a collection to get a unique list. He also
shows how that list can be sorted (you may want to do that):
http://j-walk.com/ss/excel/tips/tip47.htm