1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Private Sub ComboBox1_Change()
Dim sh As Worksheet
If Me.ComboBox1.Value = "" Then Exit Sub
Set sh = Sheets("LAD")
li = Me.ComboBox1.ListIndex + 5
Me.TextBox2 = sh.Cells(li, 1)
Me.TextBox4 = sh.Cells(li, 6)
Me.TextBox5 = sh.Cells(li, 2)
With Me.ComboBox1
.RowSource = "Noms"
.Value = sh.Cells(li, 5)
End With
Me.TextBox2 = sh.Cells(li, 1)
Me.TextBox4 = sh.Cells(li, 6)
Me.TextBox5 = sh.Cells(li, 2)
End Sub
Private Sub CommandButton1_Click()
Unload UserForm1
End Sub |
Partager