Private Sub tous_Change(txtb, bkcolor, fontcolor, mot$)
Dim X
X = Abs(LCase(Me.ActiveControl.Value) = mot)
With txtb
.BackStyle = X
.BackColor = bkcolor
.ForeColor = fontcolor(X)
End With
End Sub
Private Sub colonne2_Change()
tous_Change colonne1, vbYellow, Array(vbBlack, vbRed), "oui"
End Sub
Private Sub colonne3_Change()
tous_Change colonne2, vbYellow, Array(vbBlack, vbRed), "oui"
End Sub
Private Sub colonne4_Change()
tous_Change colonne3, vbYellow, Array(vbBlack, vbRed), "oui"
End Sub
Private Sub colonne5_Change()
tous_Change colonne4, vbYellow, Array(vbBlack, vbRed), "oui"
End Sub