/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

0 vote123 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote136 views2 answers
Excel vba protect cells with formula
VBA
0 vote132 views1 answer
Vba vbcrlf chr
VBA
0 vote112 views1 answer
Remove frist letter from string vbnet
VBA
0 vote129 views4 answers
Jwt token vb.net validation
VBA
0 vote129 views1 answer
Check if program is running vbnet
VBA
0 vote120 views1 answer
Excel vba copy range with filter
VBA
1 vote120 views1 answer
Vba refresh pivot table
VBA
0 vote120 views1 answer
Vba remove numbers from string
VBA
0 vote144 views1 answer
Iterate all file in a folder vba
VBA

Share