/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 vote242 views1 answer
Vba format string as cash
VBA
0 vote209 views1 answer
Excel vba extract year
VBA
4 votes230 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
1 vote221 views1 answer
Excel format cell as kilowatts
VBA
0 vote217 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote229 views1 answer
Vba first cell in range
VBA
2 votes220 views1 answer
Vba file from path
VBA
4 votes226 views1 answer
Vba create directory
VBA
0 vote297 views1 answer
Amd64 vs arm64 linux
VBA
5 votes264 views1 answer
Excel vba get low byte from INTEGER
VBA

Share