Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

mtroche

Civil/Environmental
Jun 4, 2001
39
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.
 
Replies continue below

Recommended for you


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
 
Before you use the AddItem code put in Combo1.Clear and the
combobox will only show the items that are added

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor