/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 vote234 views1 answer
Remove first character from string vb
VBA
1 vote215 views1 answer
Excel vba get column name from number
VBA
0 vote222 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote294 views1 answer
Excel vba add reference programmatically
VBA
0 vote221 views1 answer
Rotate image by any angle vb.net
VBA
0 vote229 views1 answer
Returns an array from function vba
VBA
0 vote254 views1 answer
Set datetimepicker value to null vb
VBA
0 vote228 views1 answer
Excel vba unmerge sheet
VBA
0 vote235 views1 answer
VBA is form loaded
VBA
0 vote239 views1 answer
Vba clear collection
VBA