Private Sub ChargerDonnées()
Dim C As Long
If Not ComboBox2.MatchFound Then Exit Sub
If Not ComboBox1.MatchFound Then Exit Sub
If Wsh Is Nothing Then Exit Sub
Set RngLig = Wsh.[B3:K3].Offset(ComboBox2.ListIndex * 51 + ComboBox1.ListIndex)
TDon = RngLig.Value
For C = 1 To 6
Me("TextBox" & C).Text = TDon(1, C)
Next C
TextBox7.Text = TDon(1, 8)
End Sub
Private Sub CommandButton5_Click()
Dim Z As String, C As Long
TDon(1, 7) = Empty
For C = 1 To 6
Z = Me("TextBox" & C).Text
If IsNumeric(Z) Then
TDon(1, C) = CDbl(Z)
TDon(1, 7) = TDon(1, 7) + TDon(1, C)
Else: TDon(1, C) = Empty: End If
Next C
Z = TextBox7.Text
If IsNumeric(Z) Then TDon(1, 8) = CDbl(Z) Else TDon(1, 8) = Empty
RngLig.Value = TDon
End Sub