excel vba to check cell are have only letters AND NUMBER

[Zahed3570]

Hi All

This is my first post as i have joined this fantastic Forum.

I am looking for anyone to help me with a problem. I want to run a VBA Macro that will basically search a columns of names and check that each name has letters A(a) to Z(z) and possibly numbers aswell.

So

Bill Smith is valid
Bob5 Craven77 is valid
Alan *??Jones is Invalid

So the third entry would be simply made RED to highlight.

Any help is appreciated

Many thanks
Sims

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

Valid?​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]Bill Smith[/td][td]

TRUE​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]Bob5 Craven77[/td][td]

TRUE​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]Alan *??Jones[/td][td]

FALSE​

[/td][/tr]
[/table]

CF formula in A2:A4: =NOT(Zahed(A2))

Function Zahed(sInp As String) As Boolean
  Zahed = Not sInp Like "*[! 0-9A-Za-z]*"
End Function