Bonjour,
remplace ton code par celui-ci :
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("D14")) Is Nothing Then
If UCase(Target) = "CYLINDRE" Then
Range("f13") = Range("E13")
Else
Range("F13") = ""
End If
End If
End Sub
ou ceci :
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("D14")) Is Nothing Then
If UCase(Target) = "CYLINDRE" Then
Range("f13") = WorksheetFunction.Pi
Else
Range("F13") = ""
End If
End If
End Sub
Amicalement