Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect([E5:E30], Target) Is Nothing Then
Application.EnableEvents = False
On Error Resume Next
[Liste].Find(Target, LookAt:=xlWhole).Copy Target
Target.Validation.Add xlValidateList, Formula1:="=Liste"
Application.EnableEvents = True
End If
End Sub