/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 vote240 views1 answer
Vbnet hex to binary
VBA
0 vote237 views1 answer
Excel vba remove formatting from cell
VBA
0 vote254 views1 answer
Vba open report
VBA
0 vote236 views1 answer
Search combobox items vb.net
VBA
0 vote273 views1 answer
Excel vba convert cells address
VBA
0 vote226 views1 answer
Vba shape transparent
VBA
0 vote233 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote253 views1 answer
Vba foreach 2d array
VBA
0 vote238 views1 answer
Excel vba formatconditions positive
VBA
0 vote261 views2 answers
S yyyy-MM-dd em vb net
VBA

Share