VBA to determine if Federal ID or Social Security #

[mikeburg]

What would be the simplest VBA to determine if a cell E7 contains:

A federal ID always 9 digits with only one hyphen which is always after the 1st two numbers. For example: 12-3456789

or

A social security number always 9 digits with only two hyphens which are always 1 hyphen after the 1st 3 numbers & the other hyphen after the next 2 numbers. For example 123-45-6789.

In other words,

If Range("E7") = a federal id then
or
If Range("E7") = a social security number then

I really appreciate your help. mikeburg

[Palmetto]

Since the first hyphen is always either the third character or fourth, you only need to check this character once.

Please Login or Register  to view this content.

[Leith Ross]

Hello Mikeburg,

You can use a UDF to validate the cell contents using the Like operator for pattern matching.

Please Login or Register  to view this content.

[shg]

Or ...

Please Login or Register  to view this content.

[mikeburg]

Hey, thanks a million for your help! This answers my question. They work great! mikeburg