1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| linsuiv = Sheets("G° HORAIRE").Range("C1048576").End(xlUp).Row + 1
r = MsgBox("Confirmez-vous cette modification ?", vbYesNo, "Validation")
If r <> 11 Then Exit Sub
For i = 1 To linsuiv 'i allant de 1 a la derniere ligne du tableau, tous les champs se charge en f° du contenu
'de la cb
While ComboBox4.Text = Cells(i, 3)
Rows(i).Select
Cells(i, 4) = TextBox2.Text
Cells(i, 5) = TextBox3.Text
Cells(i, 6) = ComboBox1.Text
Cells(i, 7) = TextBox5.Text
Cells(i, 8) = ComboBox2.Text
Cells(i, 9) = ComboBox3.Text
Cells(i, 10) = TextBox8.Text
Cells(i, 11) = TextBox9.Text
Cells(i, 12) = TextBox10.Text
Cells(i, 13) = TextBox12.Text
Cells(i, 14) = TextBox11.Text
i = i + 1
Wend
Next i
'Mise à jour automatique des champs apres confirmation des modifications
Me.ComboBox4.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
ComboBox1.Text = ""
TextBox5.Text = ""
ComboBox2.Text = ""
ComboBox3.Text = ""
TextBox8.Text = ""
TextBox9.Text = ""
TextBox10.Text = ""
TextBox12.Text = ""
TextBox11.Text = ""
End Sub |
Partager