When requesting information from a user in Excel it is important that the information received matches the styling and format that is required. If you are requesting a number for a percentage, and the user enters text, any formula dependent on the percentage will return an error. It becomes increasingly important to provide validation to prevent erroneous data from being entered.
In this recipe, you will learn how to use validation to limit and direct the values entered into the Excel worksheet.
For this recipe, we will use the input worksheet built and used in the previous recipe, Directing with conditional messages.
The following user form requires that the user enters certain information in order to calculate a loan. Input 1 located in cell C2 requires a number to be calculated as a percentage.
1. Select cell C2, then select the Data tab from the Excel toolbar:
2. From the Data Tools menu, select Data Validation:
3. The Data...