/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 vote240 views1 answer
Vbnet round to nearnest thousand
VBA
3 votes254 views2 answers
Vba date to string
VBA
3 votes244 views1 answer
Vba request json
VBA
0 vote231 views1 answer
Supprimer la valeur de celule vba
VBA
4 votes227 views1 answer
Excel vba how to reset usedrange
VBA
0 vote227 views1 answer
Nested if else in vb.net
VBA
0 vote256 views1 answer
.net crash app
VBA
1 vote244 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote248 views1 answer
Excel R1C1 mode
VBA
1 vote253 views1 answer
Find and replace textbox
VBA

Share