Create Custom Error Message

Asked By dawn fraserr 0 points N/A Posted on - 07/01/2019

How can I create Custom Error message in Excel? I want to keep restrictions.

• Status: Open
• Question Views: 63
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: Error

Answered By Mario L Horne 10 points N/A #318863

Create Custom Error Message

To create an error message, select the cell or press E6 in which you want to add restrictions too. Then go to Data, Data validation, then there will be few options in the settings;

i) Allow; select Whole Number

iii) Data; choose the option Between

iii) Minimum; 25

iv) Maximum; 50

Then go to input message, add the title whatever you like to add like Age Applied Restriction. In input, message writes: the maximum age is 50, and the minimum age is 25. Then go to Error Alert. In the style option, you may write ‘Stop,’ and in the title, you can add ‘hey Stop.’ you can apply some message down like ‘you can’t proceed further.’ Now you can check your error message.

About Mario L Horne

Questions
8

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/01/2019
• Question Category: Software Others