Data Validation - ALL CAPS
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
Daily posts of Excel tips…and other stuff
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
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Leave a comment