/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 vote149 views1 answer
Excel autofilter vba
VBA
0 vote169 views1 answer
Internet explorer reference vba
VBA
1 vote160 views2 answers
Excel vba password protect
VBA
2 votes176 views1 answer
Vba split string
VBA
0 vote187 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
5 votes181 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote167 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote157 views1 answer
Create new worksheet excel visual basic
VBA
0 vote184 views1 answer
Vba dictionary clear
VBA
0 vote177 views1 answer
Refer to resource using string variable vb.net
VBA