View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default UserForm ComboBox RowSource linked to Column with duplicate values

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

--