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]

	A​	B​
1​	​	Valid?​
2​	Bill Smith	TRUE​
3​	Bob5 Craven77	TRUE​
4​	Alan *??Jones	FALSE​

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