Adding Unique Items to ComboBox From Another File/Workbook

jonny · Aug 31st 2006

I need to add about ~200 items to Combo From Other Excel File (with no duplcates).
How to make it.

Code

Private Sub UserForm_Activate()
    With cboComp
         .addItem "item"
    End With
End Sub

Thanks

Ivan F Moala · Aug 31st 2006

Re: Adding Items to Combo From Another File

You need to think how you would get duplicates manually using native Excel.
So one method to do this is to use Advanced filter.

Basically (Provided file is open)
Advance fileter on Data (unique), Place data in std location.
Loop through this location adding to combobox.

Thats the steps to take for one way to do this.

Post back if you have problems in doing the code and I'm sure someone can help you through it.

Dave Hawley · Aug 31st 2006

Re: Adding Items to Combo From Another File

Reference the needed list in your UserForm Workbook via basic reference formulas. Then use AdvancedFilter to get only Uniques and then set a [dr]*[/dr] to that list and use the name in the RowSource of the ComboBox.

Hey Ivan, long time no see

Dave Hawley · Aug 31st 2006

Re: Adding Items to Combo From Another File

See also Add a unique and sorted list to a ListBox

Adding Unique Items to ComboBox From Another File/Workbook

Participate now!

Share