How do I show a list of unique items in a ComboBox?

[mtroche]

My program is in VBA. I have a ComboBox showing the items from an array, but there are some repeated items and I don't want to show the same item twice or more in any ComboBox. How can I do it? How can I make the ComboBox to show each item from the same array just one time and don't show repeated items? I will appreciate any help.

 

[kiso]

I don't know any shortcuts to your problem. You'll just have to do it the hard way; before adding the item, check if it already exists.

You can use the "Like"-operator, "InStr"-function or "StrComp"-function to check for the existance.

Kim

 

[gaba]

Before you use the AddItem code put in Combo1.Clear and the
combobox will only show the items that are added