Consider while creating a pre-set field for other users which will be helpful when entering the value that you have already set where you do not want users to enter the information on their own.
With the use of Data Validation feature in excel you can create your own custom error message when the user enter the information which is not predefined.
Let us take an example:
If we want user to enter number between 1 & 10 then the user will not be able to enter any other number like -1, 0, 11 & so on.
To prevent the user from entering numbers other than between 1 & 10, we will use Data Validation Error Alert.
Now, when you enter value other than between 1 & 10 then the following dialog box will appear.
In case you want user to be able to enter the value skipping the error message
In this way you can show the custom error messages that you want to show.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.