Another Example Using Data Validation

You want your users to be successful when they fill in the weekly timesheet.

 

Data Validation can also be used to ensure data integrity. Data Integrity means the user typed in the value that belongs to the cell.

 

For example: did your users enter today's date instead of number of hours in the time sheet?

 

Instead of a combo box, this example will use an Input Message and Error Alerts to prompt users to enter the correct data.

 

Try It: Validate the Hours

Select: Cell B5.

Go to Data -> Data Validation.