In Excel, custom input or error messages explain the rules for each field to prevent data-item errors. Imagine, for instance, that it`s your job to create, maintain, and assign user IDs and passwords for your company employees. You create a spreadsheet to perform this task. Then you get transferred. So now you have to delegate this task to someone else. The best way to ensure the job is done right is to create input and error messages. For the User IDs, first create an Error Alert that says, `No duplicates allowed.` Then create an Input Message that, when displayed, explains what kind of data can be entered. And last, a backup Error Message for column E that says: `Only 7 digits allowed.`To read this article in full, please click here
|