/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 vote183 views1 answer
Vba simple quote
VBA
0 vote180 views1 answer
Visual basic run command
VBA
4 votes166 views2 answers
Vba array length
VBA
3 votes186 views1 answer
Excel vba change format of cell
VBA
0 vote169 views1 answer
Switch pictures with buttons vb.net
VBA
3 votes170 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote171 views1 answer
Vbs expand env var
VBA
0 vote188 views1 answer
Vba open report
VBA
0 vote171 views1 answer
Xlbycolumns is not declared
VBA
1 vote183 views1 answer
Change the first item in a queue vb.net
VBA

Share