/VBA/Excel vba check if string entirely alpha

Excel vba check if string entirely alpha

Excel vba check if string entirely alpha

'VBA function to check if string is ENTIRELY alpha:

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

2

Source: academy.excelhero.com

Similar codes

3 votes366 views1 answer
Vba double quote
VBA
8 votes456 views1 answer
Vba make a short integer from two bytes
VBA
18 votes533 views2 answers
Vba make word from bytes
VBA
0 vote324 views1 answer
Excel vba center userform
VBA
0 vote345 views1 answer
Vba get workbook name
VBA
0 vote331 views1 answer
Compare dates vb
VBA
0 vote333 views1 answer
Show unix time in vba
VBA
3 votes357 views1 answer
Excel vba get the workbook full filename with path
VBA
11 votes480 views1 answer
Excel vba How to URL encode a string
VBA
0 vote370 views1 answer
Excel vba Column Name from Column Number
VBA

Share