• About cells
• Block Renumber dialog
• Calculation Explorer
• Calculation Reference Dialog
• Using The Cell Picker Dialog
• Cell Renumber dialog
• Cell Validation
• Clipboard Cell Conflict dialog
• Creating a Response and Assigning an Action for Invalid Input
• Creating A Validation Rule
• Modify Group Tab dialog
• Recalculate Error dialog
• Recalculation Error dialog
• Renumber Sum Group dialog
• Set Cell Group dialog
• Set Sum Group dialog

Cell Validation

Input validation can be used on numeric and alphanumeric cells and an action can be set that is triggered when this validation fails. Input mode and validation can be used for date cells because date cells have an option to use Calender Control to capture the date input or allow the user to type in the specified date into the cell. There are three sections that need to be completed to set up input validation for a cell: Validation, Response and Action.

Validation

The rules that will be used to test the validity of input to a cell are set up in the Validation section.

Response

The Response section is used to construct the message that will be displayed to users when invalid input is entered into a cell.

Action

The Action section defines what will occur when invalid input is entered into a cell.

How Do I?

• Creating a Validation Rule
• Creating a Response and Assigning an Action for Invalid Input