Private Sub TextBox15_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Select Case Val(TextBox15)
Case Is < 1500
Me.TextBox15.BackColor = vbWhite
Me.TextBox15.ForeColor = vbBlack
Me.TextBox15.Font.Bold = False
Case Is > 1500
Me.TextBox15.BackColor = vbRed
Me.TextBox15.ForeColor = vbWhite
Me.TextBox15.Font.Bold = True
End Select
End Sub
Private Sub TextBox15_AfterUpdate()
If Me.TextBox15.Value > 1500 Then
Me.TextBox15.BackColor = vbRed
Me.TextBox15.ForeColor = vbWhite
Me.TextBox15.Font.Bold = True
Else
Me.TextBox15.BackColor = vbWhite
Me.TextBox15.ForeColor = vbBlack
Me.TextBox15.Font.Bold = False
End If
End Sub
Private Sub TextBox15_Change()
Dim test As Boolean
With TextBox15
test = Val(Replace(.Text, ",", ".")) > 1500
.BackColor = IIf(test, vbRed, vbWhite)
.ForeColor = IIf(test, vbWhite, vbBlack)
.Font.Bold = test
End With
End Sub
Private Sub TextBox15_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Select Case Val(TextBox15)
Case Is < 1500
Me.TextBox15.BackColor = vbWhite
Me.TextBox15.ForeColor = vbBlack
Me.TextBox15.Font.Bold = False
Case Is > 1500
Me.TextBox15.BackColor = vbRed
Me.TextBox15.ForeColor = vbWhite
Me.TextBox15.Font.Bold = True
End Select
End Sub
Bonjour,
Ajoute ceci dans ton Usf
VB:Private Sub TextBox15_AfterUpdate() If Me.TextBox15.Value > 1500 Then Me.TextBox15.BackColor = vbRed Me.TextBox15.ForeColor = vbWhite Me.TextBox15.Font.Bold = True Else Me.TextBox15.BackColor = vbWhite Me.TextBox15.ForeColor = vbBlack Me.TextBox15.Font.Bold = False End If End Sub
Merci de vos réponses du coup j'ai pris le deuxième code de vb et tout fonctionne comme je le souhaite merci encore ç vous deux et bonne soiréeBonjour Bizarre, M12,
Ou aussi :
A+VB:Private Sub TextBox15_Change() Dim test As Boolean With TextBox15 test = Val(Replace(.Text, ",", ".")) > 1500 .BackColor = IIf(test, vbRed, vbWhite) .ForeColor = IIf(test, vbWhite, vbBlack) .Font.Bold = test End With End Sub
Un fil est résolu quand on a choisi un post comme solution.Merci de vos réponses du coup j'ai pris le deuxième code de vb et tout fonctionne comme je le souhaite merci encore ç vous deux et bonne soirée
comment marquer résolu
Private Sub TextBox1_Change()
Dim V#:
With TextBox1
V = Val(Replace(.Value, ",", "."))
.BackColor = Array(vbWhite, vbRed)(Abs(V > 1500))
.ForeColor = vbWhite * (Abs(V > 1500))
.Font.Bold = .ForeColor = vbWhite
End With
End Sub
Private Sub TextBox1_Change()
With TextBox1
.BackColor = vbWhite: .ForeColor = vbBlack: .Font.Bold = False
If Val(Replace(0 & .Text, ",", ".")) > 1500 Then .BackColor = vbRed: .ForeColor = vbWhite: .Font.Bold = True
End With
End Sub
Val(Replace(.Value, ",", "."))
Sinon, en terme simple, à quoi correspond :
VB:
Val(Replace(.Value, ",", "."))