/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

4 votes208 views2 answers
Vba create folder if not exist
VBA
0 vote284 views1 answer
Vba change active sheet
VBA
0 vote213 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote204 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote212 views1 answer
Find database connection string vb
VBA
0 vote191 views1 answer
Vbnet check if string is only symbols
VBA
0 vote192 views1 answer
Refresh token em vb net
VBA
0 vote205 views1 answer
Vba remove the first character of string
VBA
1 vote186 views1 answer
Vba delete array element
VBA
0 vote201 views1 answer
Vbnet chart make 0 gridline line different color
VBA

Share