Hello all,

Having an annoying time with trying to work out how to limit entry into a field. I have created drop down lists for a number of columns, using the data validation procedure in Excel 2007. These drop down lists change dependent on entries in other columns.

For my first column drop down list, in my Settings tab, I have 'List' selected and the following criteria written: =IF(B3="",CatList1,INDEX(BudgetAllList,MATCH(B3,SCClinList,0)))

This works in terms of the drop down. No problem there, but I'm still able to override the drop down list and enter any old jargon into the field. I want the person who enters the data to only have the option of using the drop down list. Anybody know how to restrict this? I've tried adding a STOP Error alert but that hasn't help.

Many thanks,
sparkes84