Excel Data Validation
Evaluation of Formula
The example below limits the data entry in cell E4 to whole numbers between 1 and 100. If the user makes an invalid entry, a custom message, such as the one shown below will pop-up.
Select the cell or cells that you want to limit the data entry then access the data validation feature via Data > Data Validation. A small window will come out to set the rules and customized message can be defined when the entered data is invalid.
Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.