Private Sub UserForm_Initialize()
Dim SommeA As Double
Dim SommeB As Double
Dim SommeC As Double
With Worksheets("BDD")
For i = 1 To 12
Me.Controls("TextBoxH" & i).Value = CStr(24 * Int(.Range("AH" & i + 4)) + DatePart("h", (.Range("AH" & i + 4)))) & ":" & Format(.Range("AH" & i + 4), "Nn") 'Format(CDate(.Range("AH" & i + 4)), "hh:mm") 'Heure
Me.Controls("TextBoxA" & i).Value = Format(.Range("AI" & i + 4), "##0.00") 'Somme1
SommeA = SommeA + IIf(.Range("AI" & i + 4) = Empty, 0, .Range("AI" & i + 4))
Me.Controls("TextBoxB" & i).Value = Format(.Range("AJ" & i + 4), "##0.00") 'Somme2
SommeB = SommeB + IIf(.Range("AJ" & i + 4) = Empty, 0, .Range("AJ" & i + 4))
Me.Controls("TextBoxC" & i).Value = Format(.Range("AL" & i + 4), "##0.00") 'Somme3
SommeC = SommeC + IIf(.Range("AL" & i + 4) = Empty, 0, .Range("AL" & i + 4))
Next i
Me.TextBox141.Text = CStr(24 * Int(.Range("AH17")) + DatePart("h", (.Range("AH17")))) & ":" & Format(.Range("AH17"), "Nn")
Me.TextBox142.Text = Format(SommeA, " ### ##0.00")
Me.TextBox143.Text = Format(SommeB, " ### ##0.00")
Me.TextBox144.Text = Format(SommeC, " ### ##0.00")
End With
End Sub