vba isalpha code example
Example: excel vba check if a string only contains alpha characters
'VBA function to test if a string contains only letters:
Function IsAlpha(s) As Boolean
IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function
'VBA function to test if a string contains only letters:
Function IsAlpha(s) As Boolean
IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function