I'm using a drop down list dependant on a previous drop down list. The first
list restricts entries to the data list, and disallows any other entry. The
second list however, provides the relevant options based on the first list,
but also allows me to input anything (ljafsdlkjfd for example) without giving
an error message. Am I missing something or is this a limitation of the excel
software or the code that's being used? I do have the "stop" option ticked
for the validation in the dependant dropdown list.

Any suggestions appreciated.

Cheers,

Alan.