Page 79 - Excle-En-V3

An error Alert message can also be added to alert the data entry user that there
is an error when typing a number in the cell that is being worked on through the
"Error Alert" tab. Type the message title at Title and the message content at Error
Message. Choose the warning type from Style, then click OK.

Figure 110: Data Validation Error Alert

This message will appear when entering a wrong number in the cell you are
verifying its data. This is because you have violated the rule of verification and you
typed a letter instead of typing a whole number between No. 6 and No. 8. Here, if
you click “No" the program will reject what you typed into the cell because it is a
mistake and contrary to the rule that was set. If you choose "yes", the program will
accept what you typed into the cell.

Figure 111: executing an error in data validation

71 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024