/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

1 vote246 views1 answer
Vba listindex select multiple items vba
VBA
0 vote282 views1 answer
Vba clear collection
VBA
1 vote268 views1 answer
Vba optional
VBA
3 votes252 views1 answer
Excel vba last row in range
VBA
0 vote294 views2 answers
VB
VBA
4 votes250 views1 answer
Excel vba how to reset usedrange
VBA
0 vote277 views1 answer
Excel vba disable keyboard input
VBA
0 vote313 views1 answer
Winforms dark title bar
VBA
0 vote288 views1 answer
Vba character ascii code
VBA
2 votes274 views1 answer
Vba split string
VBA