ComboBox / ListBox avoiding duplications

[Richard]

I'm trying to find out how to add values to a ComboBox from a
spreadsheet using VBA whilst avoiding duplications.
I'm stripping out the relevant values using VBA and adding them to the
ComboBox, the list contains many instances of the same value, and I am
looking to show each value ONLY ONCE in the ComboBox. As the stripping
out process can rely on up to 5 prerequisits, sorting of the source
data is not feasible. Can anyone suggest how I can do this?

Rich

 

[Bob Phillips]

Hi Rich,

You could always filter the source data using Advanced Filter and the Copy
Unique option to create a list of unique items, and then point the Combobox
at that newly filtered range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)