/VBA/Excel vba check if a string only contains letters

Excel vba check if a string only contains letters

'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

Source: academy.excelhero.com

Similar codes

0 vote151 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote132 views1 answer
How to extract a file from an ISO:
VBA
0 vote131 views1 answer
Vba text to general
VBA
0 vote149 views1 answer
Vba paste values
VBA
0 vote137 views1 answer
Make your computer talk vbscript
VBA
0 vote132 views1 answer
Vba first cell in range
VBA
5 votes142 views1 answer
Xl vba double quotes in string literal
VBA
0 vote137 views1 answer
Hello world vb.net
VBA
0 vote137 views1 answer
Vb check if row has column
VBA
0 vote131 views1 answer
Vba file size
VBA