Bonjour André13,
J'ai un message d’erreur sur le fonction recherche ci dessous surligne en vert :
Private Sub ListBox1_Click()
For i = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(i) = True Then
ln = i
Exit For
End If
Next i
'MsgBox ListBox1.Column(16, i)
colA = Array(1, 2, 3, 4, 14, 15, 6, 8, 7)
tb = Array(1, 2, 3, 4, 8, 9, 5, 7, 6)
For i = 0 To 8
Controls("Textbox" & tb(i)) = ListBox1.Column(colA(i) - 1, ln)
Next i
colB = Array(16, 5, 13, 10, 12, 9)
cb = Array(7, 1, 2, 6, 4, 3)
For i = 0 To 5
Controls("combobox" & cb(i)) = ListBox1.Column(colB(i) - 1, ln)
Next i
End Sub
Cordialement
Yann