MS Excel Add Error Messages
HOME Data Validation – Restricting what data go in a cell. You can also restrict what goes in to a cell on your spreadsheet, and display an error message for your users. We will do this with our comments column. If users enter too much test, we will let them know by displaying a suitable error box. Try the following: Highlight the E column on your spreadsheet (the comments column). From the Data Tools panel, click Data Validation to bring up the dialogue box again. From the Allow list, select Text length: When you select Text length from the list, you will see three new areas appear: What we are trying to do is to restrict the amount of text a user can input into any one cell on the Comments column. We will restrict the text to between 0 and 25 characters. The first of the new areas (Data) is exactly what we want – Between. For the minimum textbox, just type a 0 (Zero) in there. For the maximum box, type...