Re : changement couleur USF sous condition
remoi:
essai ceci a la place
Private Sub TextBox1_AfterUpdate()
If TextBox1.Value < 10 Then
TextBox1.BackColor = &HFF&
Else:
TextBox1.BackColor = &H8000000E
End If
End Sub
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim defaut As String
defaut = UserForm1.BackColor
If TextBox1.BackColor = &HFF& Then
UserForm1.BackColor = RGB(255, 0, 0)
Else:
UserForm1.BackColor = defaut
End If
End Sub
A+