Private Sub UserForm_Initialize()
Dim oLO As ListObject
Dim oRow As Range
Dim oItem As Object
Dim CollectionMachines As New Collection
Dim sMachine As String
Dim i As Long
Set oLO = ThisWorkbook.Worksheets("machines").ListObjects("Tableau7")
For Each oRow In oLO.DataBodyRange.Rows
sMachine = CStr(oRow.Columns(oLO.ListColumns("N° SIS").Index).Value)
If Len(Trim(sMachine)) > 0 Then
CollectionMachines.Add sMachine
End If
Next
SortCollection CollectionMachines
For i = 1 To CollectionMachines.Count
cmbMachines.AddItem CollectionMachines.Item(i)
Next
End Sub
c'est sur trim que ca plante apparemment