ComboBox displays duplicates - please help
 

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
--
Jeff

ComboBox displays duplicates - please help
 

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

Jeff wrote:

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
--
Jeff

--

Dave Peterson

ComboBox displays duplicates - please help
 

Thank you, it is very helpful. :-)

--
Jeff


"Dave Peterson" wrote:

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

Jeff wrote:

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
--
Jeff

--

Dave Peterson