/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 vote245 views1 answer
Vba simple quote
VBA
0 vote257 views2 answers
VB
VBA
0 vote239 views1 answer
Excel vba formatconditions positive
VBA
0 vote253 views1 answer
Excel vba urlmon
VBA
1 vote230 views1 answer
If inputbox cancel vba
VBA
0 vote241 views1 answer
Vba excel parser xml
VBA
0 vote239 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote321 views1 answer
Vba change active sheet
VBA
0 vote251 views1 answer
How to mount floppy disks in vb.net
VBA
3 votes237 views1 answer
Excel insert blank row for value change in column
VBA