/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 vote216 views1 answer
Get month number from month name vbnet
VBA
0 vote198 views1 answer
Vb test if reference is null
VBA
0 vote296 views1 answer
Vba change active sheet
VBA
0 vote198 views1 answer
Excel vba disable copy paste
VBA
-1 vote200 views1 answer
Text to speech vb.net
VBA
1 vote206 views1 answer
Export datagridview to excel vb.net
VBA
8 votes262 views1 answer
Excel vba make word
VBA
0 vote224 views2 answers
Vb.net include quotes in string
VBA
0 vote221 views4 answers
Jwt token vb.net validation
VBA
0 vote201 views1 answer
Vba collection key list
VBA