Here is what exactly i am looking ..in the below link u will find each state driving license formats of ..example for alabama 7 Numeric..for ALASKA Up To 7 Digits..what am i looking is if we select a specific state and then insert any driving license of that state in next cell if the format matches i want that next cell to be true if not false ..wonder if we can create anything like this ..there are about 50 states with different license formats..

Please check if we can write a VBA for this ..



http://www.diogenesllc.com/stdlformats.html