Option Explicit
Private Sub Valid2009_Click()
Dim Nom_CE As String
Nom_CE = Sheets("PARAM").[AH10]
Dim Cible As Range
Sheets("BDCE").Select
Set Cible = Range("E10:E10000").Find(Nom_CE, lookat:=xlWhole) 'Cherche le C.E.
Cible.Offset(0, 1).Value = ComboBox2.Value
If ComboBox2.Value = "Non" Then Cible.Offset(0, 1).Font.ColorIndex = 48
End Sub