le fichier est volumineux je vous envois le code de programme dans mon textbox
Private Sub TextBoxRMN_Change()
TextBoxRC.Value = (Val(TextBoxRM) + Val(TextBoxRNI) - Val(TextBoxRMN)) / 2
'TextBoxRC = Replace(TextBoxRC.Value, ",", ".")
TextBoxC = TextBoxRC / (2 * TextBoxRM)
If (Me.TextBoxRC.Value < 0) Or (Me.TextBoxC > 0.15) Or (TextBoxRNI.Value < TextBoxRNG.Value) Then
CheckBoxenregistrer.Visible = True
Label26.Visible = True
Me.Label26.BackColor = RGB(255, 0, 0)
End If
If (Me.TextBoxRC.Value > 0) And (Me.TextBoxC <= 0.15) And (TextBoxRNI.Value > TextBoxRNG.Value) Then
CommandButtonAjouter.Enabled = False
CheckBoxenregistrer.Visible = False
CommandButtonAjouter.Enabled = True
CheckBoxenregistrer.Value = False
Label26.Visible = False
End If
End Sub