Hi,
I created a drop down list (using data validation). After creating the drop
down If i type any text or if i copy and paste the data in the drop down list
it is accepting. Can you pls. tell me how can i stop typing, copying in the
drop down list (I want to stop that and say pick up from the drop down). I
tried all the options but still i missing something. I request your hepl here.

Thanks in advance!!!

-Chr