How to remove Duplicate Item from ListBox in Excel VBA

preview_player
Показать описание
Remove Duplicate Item from ListBox in Excel VBA
If you want to remove duplicate values in Listbox or want to add unique item on ListBox, then follow my video..
If you don't have any idea to populate ListBox based on TextBox Value then the below video first.
How to Populate ListBox based on TextBox value click the below link
If you want to populate listbox more than 10 Column then
To View VBA Code and download this file Please visit my blogs
Рекомендации по теме
Комментарии
Автор

Teşekkürler. Daha kısa 1.değeri bulduktan sonra (Exit For) çıkış yapılabilir.

With Me.ListBox1

.AddItem sh.Cells(i, 2)

.List(.ListCount - 1, 1) = sh.Cells(i, 3)

.List(.ListCount - 1, 2) = sh.Cells(i, 4)

.List(.ListCount - 1, 3) = sh.Cells(i, 5)

.List(.ListCount - 1, 4) = sh.Cells(i, 6)

.List(.ListCount - 1, 5) = sh.Cells(i, 7)

End With

Exit For



End If

Next x

Next i

sedataksakal