/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

3 votes317 views1 answer
Vba http request json
VBA
0 vote312 views1 answer
Make all controls in an area not visable vb
VBA
0 vote307 views1 answer
Default host vbox address
VBA
0 vote323 views1 answer
Excel vba DisplayAlerts
VBA
0 vote318 views2 answers
Excel vba copy paste after last row
VBA
9 votes448 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote312 views1 answer
Thread sleep vb
VBA
0 vote270 views1 answer
How to self delete a vbscript file
VBA
0 vote310 views1 answer
Xlbycolumns is not declared
VBA
0 vote312 views2 answers
Vba remove line breaks
VBA