UserForm ComboBox RowSource linked to Column with duplicate values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PCLIVE - 11 Apr 2008 16:15 GMT

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

--

Reply to this Message

JLGWhiz - 11 Apr 2008 16:45 GMT

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.

> 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
[quoted text clipped - 5 lines]
> Thanks in advance.
> Paul

Reply to this Message

PCLIVE - 11 Apr 2008 17:06 GMT

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

Thanks,
Paul

> As a matter of practice, I usually make my row source data into unique
> items
[quoted text clipped - 18 lines]
>> Thanks in advance.
>> Paul

Reply to this Message