One use for Data Validation is to force the user to enter all capital letters. Use the Custom option and set up the Validation like this
One use for Data Validation is to force the user to enter all capital letters. Use the Custom option and set up the Validation like this
Posting code? Use <pre> tags for VBA and <code> tags for inline.