/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

1 vote170 views1 answer
How to open cmd with vbd
VBA
0 vote167 views1 answer
How to sort datagridview in vb.net
VBA
0 vote219 views1 answer
Vba len variant
VBA
4 votes229 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote225 views1 answer
Show unix time in vba
VBA
0 vote222 views1 answer
Vba horizontalalignment
VBA
2 votes280 views1 answer
Vba round number
VBA
0 vote226 views1 answer
String contins in vba
VBA
0 vote221 views1 answer
Vbs
VBA
4 votes258 views1 answer
Excel vba how to get a range's full address including sheet name
VBA

Share