/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 vote167 views1 answer
Excel autofilter vba
VBA
0 vote225 views1 answer
How to extract a file from an ISO:
VBA
-1 vote248 views1 answer
Vba sendkeys
VBA
5 votes240 views1 answer
Xlvba double quotes in string literal
VBA
0 vote244 views1 answer
How to make a a msgbpx in vbs
VBA
8 votes294 views1 answer
Excel vba make word
VBA
0 vote226 views1 answer
Vba apostrophe chr
VBA
0 vote215 views1 answer
Do until vb.net
VBA
0 vote226 views1 answer
Make all controls in an area not visable vb
VBA
5 votes251 views1 answer
Excel vba how to unit test vba code
VBA