To accept the defaults, we use the Send Key function to hit the enter key.
Regular expressions are a good way to validate text fields such as names, addresses, phone numbers, and other user information. A regular expression can easily check whether a user entered something that looks like a valid phone number.
For security a password should never be displayed in HTML or sent by email.
You can use them to constrain input, apply formatting rules, and check lengths. By using capturing groups to remember each set of digits, the same regular expression can be used to replace the subject text with precisely the format you want.
Regex class for validate any input string for any specific format.
If linking work orders to customer order lines is common practice in your work place you might want to consider this option - So the decision to link work orders to customer order lines may rest on the person entering the sales order.
You can streamline this process (and make the decision automatically) coding the business logic into an On Save macro.