/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 vote232 views1 answer
Vba registry settings
VBA
0 vote201 views1 answer
Vb net show lines for all axis labels in chart
VBA
2 votes210 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote192 views1 answer
Excel protect cells with formulas
VBA
2 votes197 views1 answer
Excel vba date to string conversion
VBA
0 vote198 views1 answer
Excel vba address not absolute
VBA
0 vote213 views1 answer
Vba sort multiple columns
VBA
0 vote217 views1 answer
Default host vbox address
VBA
0 vote190 views1 answer
Change "location" of binding navigator vb
VBA
0 vote197 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA