Can you not just use validation? - go to data and choose
validation.

-----Original Message-----
I want to check if a zipcode is correct.
In the netherlands the first 4 characters of a zipcode
are numbers
the next to characters are characters.
How can i test if this is the case.
I want to do this in vba and use excel 2002

Greetings hans



.