Change cell value when validation list is changed

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")

Please Login or Register  to view this content.

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

Try changing the Range("X4") to Range("X4").Value.

It makes no difference. The code works fine when it is fired after a cell without validation is updated.
It only throws an error when the worksheet_change event is triggered when selecting a value from the drop down list.

Using two different versions of the code, the Worksheet_Change event appears to be working correctly, so the next part would be to look at the information that populates the Data Validation drop down list. For my test, I created a drop down using a named range, since I do not have the same list that you do. With each change, mine is working correctly. The only thing that I can suggest is the verify the validation list and its settings. There may be something in its setup that is throwing the error. If you comment out the EnableEvents and test, are you able to choose Debug when the error is thrown? Does that point to anything?