how to populate a combobox with a list of unique values?

I just populated a combobox through listfillinrange property, just that the
column data source has repeated values... does any body would give me a clue
on how to filter just the unique vlaues on the combobox?

Thanks in advance and best regards!
Gerard!

I think you'll have to cycle through the cells in that range (and dump the
..listfillrange assignment).

John Walkenbach shows a technique at:
http://j-walk.com/ss/excel/tips/tip47.htm

His example uses a listbox on a userform, but I bet you can change it to work on
your listbox on the worksheet.

RIOSGER wrote:
>
> I just populated a combobox through listfillinrange property, just that the
> column data source has repeated values... does any body would give me a clue
> on how to filter just the unique vlaues on the combobox?
>
> Thanks in advance and best regards!
> Gerard!

--

Dave Peterson

Thanks Dave... what I did was to filter the values to get the unique values
before to assign them to the listfillrange property...

Thank you...

"Dave Peterson" wrote:

> I think you'll have to cycle through the cells in that range (and dump the
> ..listfillrange assignment).
>
> John Walkenbach shows a technique at:
> http://j-walk.com/ss/excel/tips/tip47.htm
>
> His example uses a listbox on a userform, but I bet you can change it to work on
> your listbox on the worksheet.
>
> RIOSGER wrote:
> >
> > I just populated a combobox through listfillinrange property, just that the
> > column data source has repeated values... does any body would give me a clue
> > on how to filter just the unique vlaues on the combobox?
> >
> > Thanks in advance and best regards!
> > Gerard!
>
> --
>
> Dave Peterson
>