/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 vote176 views1 answer
Vba paste values
VBA
7 votes184 views1 answer
Excerl vba array to range
VBA
0 vote171 views1 answer
Vb.net change cursor to wait
VBA
31 votes290 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
13 votes308 views2 answers
Vba write text file
VBA
0 vote179 views1 answer
Vba vbcrlf chr
VBA
0 vote156 views1 answer
Excel text to columns line break
VBA
0 vote226 views1 answer
Excel vba add reference programmatically
VBA
32 votes311 views2 answers
Excel vba column letter
VBA
-1 vote155 views1 answer
Text to speech vb.net
VBA

Share