/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 vote332 views1 answer
String contins in vba
VBA
1 vote311 views2 answers
Excel vba password protect
VBA
4 votes323 views1 answer
Excel vba check cell not empty
VBA
0 vote337 views1 answer
Excel vba calculate
VBA
0 vote344 views1 answer
Vba cell all borders
VBA
-1 vote332 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote324 views1 answer
Excel vba range contains
VBA
0 vote350 views1 answer
Nested if else in vb.net
VBA
8 votes384 views1 answer
Excel vba make integer
VBA
0 vote329 views1 answer
Refer to resource using string variable vb.net
VBA