Dim I As Byte
With Sheets("Cumul Mois")
For I = 3 To 21
.Cells(I, 3) = .Cells(I, 3) + Val(Me.Controls("Combobox_" & I + 19))
Next I
End With
En supposant que tes combobox sont sur un userform
Pour d'autres colonnes, tu rajoutes une boucle telle que :
Code:
Dim Lig As Byte, Col As Byte
With Sheets("Cumul Mois")
For Col = 3 To 17
For Lig = 3 To 21
.Cells(Lig, Col) = .Cells(Lig, Col) + Val(Me.Controls("Combobox_" & Lig + 19))
Next Lig
Next Col
End With