When using a ComboBox in a Userform, I'd like to have the RowSource linked
to a column on a sheet. However, in the event there are duplicate values in
this column, I would like the ComboBox dropdown to only show each value one
time just as the AutoFilter does. Is the ComboBox RowSource able to do
this, or would I have to filter out the duplicates in another column first
and then set that as the RowSource?

Thanks in advance.
Paul

--

As a matter of practice, I usually make my row source data into unique items
and sort them before linking them to a control such as combobox or listbox.
It seems to make things more efficient. The RowSource property does not
automatically do this function. You would have to build the filter and sort
processes into your code or do it manually before initiating the macro.

"PCLIVE" wrote:

When using a ComboBox in a Userform, I'd like to have the RowSource linked
to a column on a sheet. However, in the event there are duplicate values in
this column, I would like the ComboBox dropdown to only show each value one
time just as the AutoFilter does. Is the ComboBox RowSource able to do
this, or would I have to filter out the duplicates in another column first
and then set that as the RowSource?

Thanks in advance.
Paul

--

That's what I thought, but it never hurts to ask.

Thanks,
Paul

--

"JLGWhiz" wrote in message
...
As a matter of practice, I usually make my row source data into unique
items
and sort them before linking them to a control such as combobox or
listbox.
It seems to make things more efficient. The RowSource property does not
automatically do this function. You would have to build the filter and
sort
processes into your code or do it manually before initiating the macro.

"PCLIVE" wrote:

When using a ComboBox in a Userform, I'd like to have the RowSource
linked
to a column on a sheet. However, in the event there are duplicate values
in
this column, I would like the ComboBox dropdown to only show each value
one
time just as the AutoFilter does. Is the ComboBox RowSource able to do
this, or would I have to filter out the duplicates in another column
first
and then set that as the RowSource?

Thanks in advance.
Paul

--