/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

5 votes201 views2 answers
Excel vba write to the windows registry
VBA
0 vote182 views1 answer
Vbs write file
VBA
0 vote180 views1 answer
Excel vba scroll to cell
VBA
0 vote187 views1 answer
Vbscript abs
VBA
0 vote182 views2 answers
Excel vba protect cells with formula
VBA
0 vote161 views1 answer
Excel autofilter vba
VBA
0 vote194 views1 answer
Build an index all files of a FTP site
VBA
0 vote194 views1 answer
Excel vba urlmon
VBA
2 votes178 views1 answer
Excel vba check if key is in collection
VBA
1 vote179 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA

Share