[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.
源代码
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 恢复