/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 vote134 views1 answer
Excel vba join variant array
VBA
5 votes143 views1 answer
Xl vba double quotes in string literal
VBA
2 votes95 views2 answers
Vba exit loop
VBA
0 vote164 views1 answer
Excel vba protect shapes
VBA
2 votes140 views1 answer
Excel vba check if key is in collection
VBA
0 vote155 views1 answer
Vbscript check if string contains
VBA
0 vote154 views1 answer
If statement vdhl
VBA
22 votes263 views1 answer
Xlvba check for folder
VBA
0 vote133 views1 answer
Type excel.application is not defined vb
VBA
0 vote142 views1 answer
Vba nested dictionary
VBA