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

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

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
>