To verify if your Data Validation has worked, try entering an "invalid" value. Excel will stop or warn you if you have properly set up a Data Validation.
If you would like to look at our project that has many examples of what we have talked about so far, please click here. (The file is an Excel 2007 document).
We hope this blog has informed you on how to use Data Validation with Microsoft Excel 2007. Thank you for viewing our blog.
