It is a classic problem that programmers have to confront from time to time: teaching
VB to âread.â In my experience, you just need to dig in and do it.
Write out the rules that the expression needs to conform to.
Assess the order of the tests that need to be passed for the most likely error, and for a situation where one failure obviates certain other tests.
Then convert those rules into step-by-step code.
Use InStr() to find occurrences and positions.
If you provide some specifics, more detailed steps might become apparent...