Simple question

[Guest]

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.

 

[Leo Heuser]

One way:

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