Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub lststands_Click() Dim i As Integer Dim j As Integer i = lststands.ListIndex + 1 ThisWorkbook.Worksheets ("stands") ' remplis 1ere case vide avec stand selectionné 'verif case 1 If txtST1 = "" Then UserForm1.txtST1 = .Cells(i + 1, 1) Else 'verif case 2 If txtST2 = "" Then UserForm1.txtST2 = .Cells(i + 1, 1) Else 'verif case 3 If txtST3 = "" Then UserForm1.txtST3 = .Cells(i + 1, 1) Else 'verif case 4 If txtST4 = "" Then UserForm1.txtST4 = .Cells(i + 1, 1) Else 'verif case 5 If txtST5 = "" Then UserForm1.txtST5 = .Cells(i + 1, 1) Else 'verif case 6 If txtST6 = "" Then UserForm1.txtST6 = .Cells(i + 1, 1) End If ThisWorkbook.Worksheets ("liste_personnes") End Sub