/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 vote245 views1 answer
Vba variable number of arguments
VBA
0 vote230 views1 answer
Excel vba populate array with cell values
VBA
0 vote237 views1 answer
Loop through each cell in dgv vbnet
VBA
1 vote234 views1 answer
How to put a gridpain in a vbox
VBA
0 vote264 views1 answer
Find database connection string vb
VBA
1 vote229 views1 answer
Vba listindex select multiple items vba
VBA
4 votes181 views2 answers
Vba last row
VBA
0 vote222 views1 answer
Vba createparameter null
VBA
0 vote239 views1 answer
Move bindingnavigator vb
VBA
0 vote313 views1 answer
Find control with name vb
VBA

Share