validating a text and numeric input string

**roasty_1** · 09-11-2008, 12:28 PM

Hi

Please could someone help with the following

I need to validate what is being inputted into a cell, via a Input Box

If the input is 2 letters followed by 7 number then it is ok, otherwise they need to enter it again

AB1234567 - OK
anything esle - Not OK

thanks

roast

**NBVC** · 09-11-2008, 12:36 PM

If you are entering directly into a cell, then you can use Data|Validation..

choose Custom and enter formula:

=AND(LEN(G7)=9,NOT(ISNUMBER(LEFT(G7,2)+0)),ISNUMBER(RIGHT(G7,7)+0))

Where G7 is the cell to validate.

**roasty_1** · 09-11-2008, 12:38 PM

Originally Posted by NBVC

If you are entering directly into a cell, then you can use Data|Validation..

choose Custom and enter formula:

=AND(LEN(G7)=9,NOT(ISNUMBER(LEFT(G7,2)+0)),ISNUMBER(RIGHT(G7,7)+0))

Where G7 is the cell to validate.

thanks

will this work in VBA? or is further code required?