Thread: Getting Duplicates in ListBox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Konrad[_3_] Konrad[_3_] is offline
external usenet poster
  
Posts: 1
Default Getting Duplicates in ListBox
insert this line
UserForm3.ListBox1.Clear
before
For Each Item In NoDupes
UserForm3.ListBox1.AddItem Item
Next Item

:) Konrad
email welcome if its working remove _nospam

Reply With QuoteReply With Quote