/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 vote353 views1 answer
Vba compile error object required
VBA
1 vote390 views1 answer
Export datagridview to excel vb.net
VBA
0 vote358 views1 answer
Vbnet check if string is only numbers
VBA
0 vote373 views1 answer
Vba sheet hide unhide
VBA
5 votes938 views1 answer
Vlookup vba
VBA
0 vote361 views1 answer
Vba find sub dictionary
VBA
3 votes388 views1 answer
Excel insert blank row for value change in column
VBA
0 vote356 views1 answer
Vba word open document read only
VBA
0 vote347 views1 answer
Vbscript abs
VBA
1 vote345 views1 answer
Excel vba get column name from number
VBA

Share