How do I show a list of unique items in a ComboBox?
How do I show a list of unique items in a ComboBox?
(OP)
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.





RE: How do I show a list of unique items in a ComboBox?
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
RE: How do I show a list of unique items in a ComboBox?
combobox will only show the items that are added