Forcing Data Entry to Include a Specified Character - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Monday, January 27, 2020

Forcing Data Entry to Include a Specified Character

Forcing Data Entry to Include a Specified Character
Data Validation is an excellent way to control data entry to meet a certain condition.
In this example, suppose you want to insure that a specific character is included in a text entry for a range of cells. In the next picture, you want to enter email addresses so you want to make sure the “@” character is included. The following steps show how this can be done.
Step 1
Select the range of interest, and from your keyboard press Alt+D+L to show the Data Validation dialog box.
Step 2
In the Data Validation dialog box:
• Click onto the Settings tab.
• Click the down arrow for the Allow field.
• In the list of allowable categories, select Custom.
Step 3
In the Formula field, enter the formula that is relative to your selected range.
In this example, that formula would be =ISNUMBER(FIND("@",B2))
Step 4
Still in the Data Validation dialog box:
• Click the Error Alert tab.
• Click to enter a checkmark in the box next to “Show error alert after invalid data is entered.”
• In the Style field, from the drop down list, select Stop.
• Enter the text for the Title of the error message you want to convey.
• Enter the text for the error message you want to convey.
• Click the OK button.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment