Private Sub txtB_Change()
'la variable "tous" contient les object textbox de leur frame respective
Dim critere As Boolean, V
With mamanFram
Select Case .Name
Case "FrCdt":
V = Array(.PrixCdt.Value, .TxtSoie.Value, .TxtCordelette.Value, .TxtEtiquetteCarton.Value, .CoeffCdt.Value)
critere = V(0) <> "" And V(1) <> "" And V(2) <> "" And V(3) <> "" And V(4)
If critere Then .PRCdt = (CDbl(0)) + CDbl(V(1)) + CDbl(V(2)) + CDbl(V(3)) * CDbl(V(4))
Case "FrPlante":
V = Array(.PrixAchatPlante.Value, .CoeffPlante.Value, .PrixAchatPlante.Value, .TransPlante.Value)
critere = V(0) <> "" And V(1) <> "" And V(2) <> "" And V(3) <> ""
If critere Then .PRPlante.Value = (CDbl(V(0)) * CDbl(V(1))) + (CDbl(V(2)) * CDbl(V(3)))
Case "FrPot":
V = Array(.PrixPot.Value, .CoeffPot.Value)
critere = V(0) <> "" And V(1) <> ""
If critere Then .PRPot.Value = (CDbl(V(0)) * CDbl(V(1)))
Case "FrPlaque":
V = Array(.PrixPlaque.Value, .CoeffPlaque.Value, .NbPlantePlaque.Value)
critere = V(0) <> "" And V(1) <> "" And V(2) <> ""
If critere Then .PRPlaque = (CDbl(V(0)) * CDbl(V(1))) / CDbl(V(2))
Case "FrChromo":
If .PrixChromo.Value <> "" Then .PRChromo.Value = .PrixChromo.Value
Case "FrEtiquette":
If .PrixEtiquette.Value <> "" Then .PREtiquette.Value = .PrixEtiquette.Value
Case "FrEntourage":
If .PrixEntourage.Value <> "" Then .PREntourage.Value = .PrixEntourage.Value
Case "FrEmballage":
V = Array(.Mousseline.Value, .Kraft.Value, .DsSmith.Value)
critere = V(0) <> "" And V(1) <> "" And V(2) <> ""
If critere Then .PREmballage.Value = CDbl(V(0)) + CDbl(V(1)) + CDbl(V(2))
Case "FrTransport":
V = Array(.PoidsPlante.Value, .PrixKgPlante.Value)
critere = V(0) <> "" And V(1) <> ""
If critere Then .PRTransport.Value = (CDbl(V(0)) * CDbl(V(1)))
Case "FrAccess":
V = Array(.TxtPrixAccessoire.Value, .TxtCoeffAccess.Value)
critere = V(0) <> "" And V(1) <> ""
If critere Then .PRAccess.Value = (CDbl(V(0)) * CDbl(V(1)))
Case "FrMO":
V = Array(.TxtCoutHrMO.Value, .TxtTempsMO.Value)
critere = V(0) <> "" And V(1) <> ""
If critere Then .TxtPrMO.Value = (CDbl(V(0)) * CDbl(V1))
End Select
End With
End Sub