Public Sub TotalPièce()
Dim c As Control
Dim Résult As Double
For Each c In UserForm1.Controls
Select Case TypeName(c)
Case "TextBox"
If c.Visible = True And c.Text <> "" Then
Résult = Résult + CDbl(c.Text)
End If
End Select
Next c
UserForm1.Label1 = Format(Résult, "#,##0.00 €")
End Sub