/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 vote283 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote267 views1 answer
Excel date to unix timestamp
VBA
0 vote302 views2 answers
Excel vba number format file size
VBA
0 vote269 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote244 views1 answer
Excel vba arrondir
VBA
0 vote272 views1 answer
VBA Loop to range
VBA
1 vote273 views1 answer
Vba reverse string
VBA
0 vote287 views1 answer
Excel vba prevent saving workbook
VBA
0 vote306 views1 answer
Excel vba convert cells address
VBA
0 vote290 views1 answer
Remove last 8 characters from string vb
VBA

Share