Change cell value when validation list is changed

[Typicalalex1]

Hi. I have a cell that has a validation list. When i select a value from the list, i want the value of another cell to change automatically but it isnt working.
The list source is pointing to another sheet:
=INDIRECT("DB_DAT!$J$268:$J$275")

Private Sub worksheet_change(ByVal Target As Range)

Select Case Target.Column
Case 10
Application.EnableEvents = False
Range("X4") = "N/A"
Application.EnableEvents = True
end select

end sub

I get an error when it tries to change the cell value. Its error no. 1004.