/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 vote211 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote225 views1 answer
For each item in folder outlook vba
VBA
0 vote200 views1 answer
Vb get ip address
VBA
0 vote227 views1 answer
Delete all controls in an area vb
VBA
0 vote161 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote216 views1 answer
Vba listbox remove all items
VBA
0 vote204 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote200 views1 answer
Vba get text file content
VBA
1 vote225 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
4 votes210 views2 answers
Vba create folder if not exist
VBA

Share