A validation need --- Excel VBA (Macros)

Originally Posted by José Augusto

This formula gives you True if the 4 rules are true and False otherwise

Formula:

=IFERROR(AND(LEFT(A2,2)="V-",CODE(MID(A2,3,1))>=65,CODE(MID(A2,3,1))<=90,ISNUMBER(0+RIGHT(A2,4)),LEN(A2)=7),FALSE)

If you want validate the use of lowercase=uppercase you can use UPPER(A2) instead A2

Thank you for the reply.But I need this from VBA frnd