Abbreviations Validation

macropod · #1 04-09-2020, 06:49 PM

Quote:

Originally Posted by mrsandes

The idea is to be able to use more than one find criteria. As we may have acronyms/abbreviations with 2 or more uppercase letters, as you had in your code, but there is also the possibility of having a lower case letter or a symbol in between uppercase letters.

In that case, try:
.Text = "\([A-Z0-9][!\) ]@[A-Z0-9]\)"

mrsandes · #2 04-14-2020, 04:32 AM

Quote:

Originally Posted by macropod

In that case, try:
.Text = "\([A-Z0-9][!\) ]@[A-Z0-9]\)"

Thanks, Paul. The only problem with that is that it doesn't find the acronyms with 2 uppercase letters only.

Even though it is not the best approach, the double verification is working, so I will stick to that.

Thank you for your support!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a list of Acronyms / Abbreviations	daithy	Word	4	03-12-2020 01:52 PM
Data Validation in Microsoft Word Template	BradleyCase	Word VBA	1	07-16-2019 12:37 PM
Adding Professional Credential Abbreviations to Name	dyny723	Outlook	0	03-16-2018 07:14 AM
Automate Job application word doc to Excel (with data validation)	dylansmith	Office	1	02-11-2018 12:58 PM
validation email address in word text filed	sameerahmad_P	Word VBA	1	03-07-2014 02:59 PM