Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Skip to end of banner Go to start of banner

Data Validation

Skip to end of metadata

Created by Alison Bird [softartisans] on Jan 31, 2014

Go to start of metadata

Intro

Define and apply data validation rules to cells with ExcelApplication.

Excel Data Validation (in Excel the menu, Data > Validation...) allows you to control what kind of data can be entered into cells by creating validation rules. You can define and apply these rules with ExcelApplication.

Code

Downloads

Template: FirstYearPayment.xlsx
Output: DataValidation_output.xlsx

No labels