/VBA/Excel vba check if a string only contains alpha characters

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

Source: academy.excelhero.com

Similar codes

0 vote152 views1 answer
Vba leading zeros in string
VBA
0 vote157 views1 answer
Vbscript remove spaces from string
VBA
0 vote134 views1 answer
How to self delete a vbscript file
VBA
8 votes207 views1 answer
Excel vba make word
VBA
1 vote161 views1 answer
Excel vba force recalculation
VBA
0 vote144 views1 answer
Vba text to general
VBA
1 vote164 views1 answer
Excel vba autofit
VBA
1 vote153 views1 answer
Add control vb
VBA
0 vote158 views1 answer
Search in richtextbox vb.net
VBA
1 vote110 views1 answer
How to open cmd with vbd
VBA