Private Sub Worksheet_Change(ByVal Target As Range)
Dim i&
With ListBox1
.Clear 'RAZ
For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
If Application.CountIf(Columns(1), Cells(i, 1)) = 1 Then
.AddItem Cells(i, 1)
.List(.ListCount - 1, 1) = Cells(i, 2).Text
End If
Next
End With
End Sub