Advertisement
3_2004-2005 Miscellaneous #134318

[Fast] Remove Duplicates From A Listbox

Removes Duplicates From A Listbox. Fastest one i've seen.

AI

AI 요약: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

소스 코드
original-source
Sub RemoveDuplicates(ListBox As ListBox)
Dim Col As New Collection
Dim i As Long
On Error Resume Next
If ListBox.ListCount > 1 Then
 For i = 0 To ListBox.ListCount - 1
 Col.Add ListBox.List(i), ListBox.List(i)
 Next
 ListBox.Clear
 For i = 1 To Col.Count
 ListBox.AddItem Col.Item(i)
 Next
 Set Col = Nothing
End If
End Sub
원본 댓글 (3)
Wayback Machine에서 복구됨