Option Explicit
Private WithEvents ClnTBxNum As CollectionTBxNum
Private Sub UserForm_Initialize()
Dim N As Long
Set ClnTBxNum = New CollectionTBxNum
For N = 1 To 13
ClnTBxNum.Add Me("USF18_TextBox" & N): Next N
TboTotal18.Text = "0"
End Sub
Private Sub ClnTBxNum_Change(ByVal TBx As MSForms.TextBox)
Dim N As Long, Valeur As Double, Somme As Double
For N = 1 To 13
Valeur = ClnTBxNum.Value(N) * Choose(N, 10000, 5000, 2000, 1000, 500, 500, 100, 50, 25, 10, 5, 2, 1)
Me("USF18_TextBox" & N + 13).Text = Format(Valeur, "### ### ##0")
Somme = Somme + Valeur: Next N
TboTotal18.Text = Format(Somme, "### ### ##0")
End Sub