/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 vote236 views1 answer
Find if year is leap year vb
VBA
-1 vote213 views1 answer
For i in range vba
VBA
0 vote221 views1 answer
Vbs write file
VBA
0 vote221 views1 answer
Excel vba copy entire sheet paste values
VBA
1 vote216 views1 answer
What does vbs stand for
VBA
0 vote216 views1 answer
Vba dropdown event
VBA
0 vote246 views1 answer
Excel vba urlmon
VBA
-1 vote217 views2 answers
How close excel through visual basic
VBA
3 votes274 views2 answers
Excel "vba" match last value
VBA
0 vote221 views1 answer
Make your computer talk vbscript
VBA