UserForm ComboBox RowSource linked to Column with duplicate values

[PCLIVE]

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

--

 

[JLGWhiz]

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]

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

Thanks,
Paul

--