Thanks Dave.

I tried using a combobox.
I have 2 problems:

1. I would like to be able to paste valid data into the cell.
2. I want to use the sam validation for more than 5000 cells, so creating a
combobox for each of them will take up too much time.

Do you maybe have another solution to my problem?

Thanks so much for your help!