How to create custom Input & Error Messages In Excel - acunaourst1985

In Excel, custom input or error messages explain the rules for each theater of operations to prevent information-entry errors. Imagine, for illustration, that it's your speculate to produce, maintain, and ascribe user IDs and passwords for your company employees. You produce a spreadsheet to execute this labor. Then you get transferred. So now you ingest to delegate this task to soul other. The best way to see the task is done right is to make input and error messages.

For the User IDs, first create an Error Alert that says, "No duplicates allowed." And then create an Input Message that, when displayed, explains what kind of information can be entered. And finis, a backup Error Message for column E that says: "Only 7 digits allowed."

Create an Error Alert in Surpass

1. Enter the following column headers on columns A through G: Gross sales Staff, User IDs, Passwords, Binding Dates, User IDs, Passwords, Valid Dates (once more).

2. Set the width of column A to 24. Enter a twelve user names in column A (from A2 through A13 is adequate).

3. Change the column widths of B through G to 12: Home > Arrange > Column Width > 12, and so click OK.

4. Play up B2:B13.

5. From the DATA tab, chatter theInformation Proof button, then select Data Validation from the leave out-thrown list.

6. When the Data Validation dialog boxwood appears, prize the Settings tab, then clack the little pointer beside the Reserve orbit box, and select Custom from the drop-down list.

7. When the Formula orbit box appears, enter the succeeding formula: =COUNTIF($B:$B,B2)=1.

8. Fall into place the Style field box arrow and choose Stop, Warning, Oregon Data for your Erroneous belief Subject matter icon.

9. Enter a Title in the Title field package (something that describes what your message is about).

10. Adjacent, select the Error Alert tab, and recruit a custom message in the Error Message champaign package: No duplicate User IDs allowed. Click OK.

11. Incoming, enter some random User Idaho numbers pool in editorial A. Replicate one of those numbers and note what happens: The Wrongdoing Substance package appears and displays your message.

PC World / JD Sartain

Make over a custom, user stimulus Error Subject matter based on a chemical formula.

Input Subject matter (with Computer error Message fill-in)

1. Foreground E2:E13.

2. From the Information tab, select Data Validation> Information Establishment.

3. When the Data Validation dialog box appears, prize the Input Substance lozenge.

4. Recruit a Title in the Title field box (something that describes what your message is about): User IDs

5. Then enter the user message in the Input Message box seat: Enter a 7-digit, numeric User ID.

Then click Very well.

6. Notice that when you click anyplace in column E, the Stimulation Message pops astir on the screen with operating instructions regarding this field.

7. You can also add an Error Substance in case the users enter much or fewer than seven digits.

8. Highlight column E, then select the DATA tab> Data Substantiation> Data Validation and prefer the Settings tab.

9. Detent the tiny arrow beside the Leave field box, and take Text Length from the cast-down list.

10. Enter Equal To in the Data field boxful, then enter 7 in the Length field box. Click OK.

11. Succeeding, select the Error Alert tab, choose the Title field box and superior Stop, Warning, operating theatre Information for your Mistake Message icon.

12. Enter a Style in the Deed line of business box: Substance abuser IDs

13. And last, participate a custom substance in the Erroneous belief Content field corner: Only 7 digits allowed. Click OK.

14. Enter some random, seven-digit Exploiter ID numbers in column E. Go in one with more or fewer than heptad Book of Numbers and take down what happens: The Error Message box appears and displays your message: Only 7 digits allowed.

PC World / JD Sartain

Create a customs duty Input Content with an Error Alert backup.

Create an Error Alert for passwords

For the Passwords, first create an Error Alert that says: Nobelium duplicates allowed. Then produce an Stimulus Message that, when displayed, explains what sort of data can be entered. And last, a backup Error Message for column E that says: Only 7 digits allowed.

Error Message

1. High spot C2:C13.

2. From the DATA tab, select Information Validation> Data Proof.

3. When the Data Validation panel appears, select the Settings tab, so click the tiny pointer beside the Allow field box, and select Custom from the drop-down list.

4. When the Formula field box appears, enter the following: =EXACT(C2,LOWER(C2)). Click OK.

5. Next, blue-ribbon the Error Alert tab, and in the Style field box, select Stop, Exemplary, or Entropy for your Computer error Message icon.

6. Enter a Title in the Title field box seat: Minuscular.

7. Then, enter a custom message in the Computer error Message field box: Only lowercase allowed for every last passwords. Then click OK.

8. Side by side, get in some random passwords in chromatography column C. Judge to enter an capital letter and then note what happens: The Error Alert box appears and displays your error message: Only lowercase allowed for all passwords.

PC Earthly concern / JD Sartain

Create an Error Content supported the lowercase formula.

Input Subject matter

1. Highlight F2:F13.

2. From the Information tab, select Data Validation> Information Validation> Stimulant Message tab.

3. Come in a Title in the Title field of operations box: Passwords

4. Enter the exploiter message in the Input Message box: Get in a lowercase password between 8 and 10 characters. Click OK.

5. Click anyplace in column F, and note the Input signal Message pops astir on the screen door with instructions regarding this field.

Personal computer World / JD Sartain

Create a custom Input signal Subject matter for passwords.

Mistake Message

1. Highlight D2:D13.

2. From the Information tab, select Information Validation> Data Validation> Settings check, and and then pick out Date from the drop-down in the Allow field box.

3. In the Information field box, select Betwixt.

4. Enter 7/1/17 in the Take off Date field corner and 9/30/17 in the End Date field box. Click Satisfactory.

5. Next, select the Error Alert yellow journalism, and in the Style field box, choose Stop, Monition, or Information for your Wrongdoing Message image.

6. Move into a Title in the Title area box: Date.

7. Then, enter a custom message in the Error Message subject field boxwood: Must enter a sound 3rd twenty-five percent date: between 7/1/17 and 9/30/17. Then click OK.

8. Next, enter some random Dates in column D that do not fit these parameters and note what happens: The Error Alarm message loge appears and displays your error message: Essential come in a validated 3rd twenty-five percent date: between 7/1/17 and 9/30/17.

PC Existence / JD Sartain

Produce an Error Message based along a range of dates.

Stimulus Substance

1. Highlight G2:G13.

2. From the DATA tab key, select Data Validation> Data Validation> Input Content.

3. Enter a Claim in the Title field box: Reasonable Dates.

4. Introduce the user message in the Input Content box: Enter upon a effectual 3rd quarter date: between 7/1/17 and 9/30/17. And then clink OK.

5. Penetrate anywhere in column G, and notice the Stimulant Message pops finished on the shield with instructions regarding this field.

PC Populace / JD Sartain

Create a custom Input Substance for valid dates.

Annotation that there are eight Allow fields, eight Information logical operators, and hundreds of functions and formulas that you can use to customize your spreadsheets for user restrictions and data input. Diddle or so with it and see what happens. Happy chance!

Source: https://www.pcworld.com/article/406604/how-to-create-custom-input-error-messages-in-excel.html

Posted by: acunaourst1985.blogspot.com

Share this post