Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Add ListBox item if item exist just once...
@fumei I gave your code a try and I don't quite understand how I can implement it. I get an error(5) at the function "CellText".. I'm using it in a "form.initialize", data source "workbooks("Data.xls").sheets(1).range("B:B"). How do I modify your code to work this way.. Sorry for the newbie...- SlyGuy77
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Add ListBox item if item exist just once...
Thanks guys.. I'll give these a try.. Thanks for the quick response.. :) Sly.- SlyGuy77
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Add ListBox item if item exist just once...
I'm trying to add items that exist just once to a listbox. I'm not talking about only having unique items in my list, I want to exclude items that exist more than once altogether. example: Items from worksheet: Item A Item B Item C Item A Desired results in Listbox: Item B Item C Hope you...- SlyGuy77
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
