Good Morning;
I’m looking for help with text validation, what I need to do is ensure a field meets certain criteria before the user can continue.
The Filed needs to start with two letters and end in one of three letters, so for example:
The end letter will only ever be the fixed letters A, B or C but the start can be anything really depending on the users first and last name.
I want this to be a manual field that users can type in but it must start with any two letters and end in only A, B or C.
Is this possible to do using VBA?
Kind Regards
Tor Fey
I’m looking for help with text validation, what I need to do is ensure a field meets certain criteria before the user can continue.
The Filed needs to start with two letters and end in one of three letters, so for example:
- MA12345678A
The end letter will only ever be the fixed letters A, B or C but the start can be anything really depending on the users first and last name.
I want this to be a manual field that users can type in but it must start with any two letters and end in only A, B or C.
Is this possible to do using VBA?
Kind Regards
Tor Fey