/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 vote205 views1 answer
Build an index all files of a FTP site
VBA
1 vote174 views1 answer
What does vbs stand for
VBA
0 vote191 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote190 views1 answer
Vba check if class implements interface
VBA
0 vote185 views1 answer
Freeze panes vba
VBA
0 vote175 views1 answer
Vbs exec hidden
VBA
0 vote198 views1 answer
Excel web scraping
VBA
1 vote185 views1 answer
Add a index column power bi
VBA
15 votes365 views2 answers
Xl vba dynamic string array
VBA
0 vote182 views1 answer
Excel vba saveas no prompt for overwrite
VBA

Share