Data Validation in TextBox with Two Digits

In this example we are validating text box with two digits integer value only.

Follow the following steps:

(i) Double click on the textbox and press Data Validation button.

(ii) From popup window click on Add button.

(iii) Select does not match pattern from second dropdown list.

(iv) Click select a pattern from last dropdown list and a popupwindow will be displayed.

(v) Select your pattern from Standard patterns list.in this case select Custom pattern.

(vi) In custom pattern put your custom pattern and press OK.

(vii) Give your messages in Screen Tip and message box.

(viii) Check the check box to show the message in browser.

(ix) Press Ok.