/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 vote122 views1 answer
Excel vba compare 2 rows
VBA
0 vote122 views1 answer
Vbs send keys
VBA
0 vote125 views1 answer
Send webhook vbscript
VBA
0 vote138 views1 answer
Regex numeric digits
VBA
1 vote137 views2 answers
Excel vba password protect
VBA
1 vote115 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote127 views1 answer
Excel vba combine ranges
VBA
0 vote130 views1 answer
Vba sort multiple columns
VBA
0 vote123 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote125 views1 answer
Limit combobox to list vba
VBA