Quote:
Originally Posted by IamThatGuy
Thanks, I have tried the steps but I am still able to enter duplicate values and enter text into the fields rather than only being allowed to select a value from the drop-down.
|
Have you set only Data Validation List values to be allowed (this is a default setting, but there is a possibility to change this)?
Anyway, I haven't access to MS Office until Friday, so I can't check out your attached workbook currently.