Quick question, I think it is easy but just cannot think
how to do it.

I want to check if a cell equals the following format.
n = Numeric Char
A = Alpha Char

N*AAANNNNN

The following 3*abc12345 would evaluate to true.

example if cells(1,1) = N*AAANNNNN then

Any help greatly appreciatted.

One way:

If Cells(1, 1).Value Like "#*[A-Z,a-z][A-Z,a-z][A-Z,a-z]#####" Then

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

skrev i en meddelelse
...
Quick question, I think it is easy but just cannot think
how to do it.

I want to check if a cell equals the following format.
n = Numeric Char
A = Alpha Char

N*AAANNNNN

The following 3*abc12345 would evaluate to true.

example if cells(1,1) = N*AAANNNNN then

Any help greatly appreciatted.