Private Sub UserForm_Initialize()
Set f = Sheets(1)
ListBox1.List = Range(f.Cells(2, 1), f.Cells(Rows.Count, 1).End(3)).Value
End Sub
Private Sub ListBox1_Click()
Dim dl&
dl = Cells(Rows.Count, 1).End(3).Row
Ligne = CStr(ListBox1.Value)
Application.ScreenUpdating = False
Range("B2:B" & dl).FormulaR1C1 = "=IF(RC[-1]=" & Ligne & ",""$$$"",0)"
Columns("B:B").SpecialCells(xlCellTypeFormulas, 2).EntireRow.Delete
Columns("B:B").Delete
Application.ScreenUpdating = True
End Sub