/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 vote293 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote222 views2 answers
Vba find last row in range for certain criteria
VBA
5 votes252 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote215 views1 answer
Vba get text file content
VBA
0 vote215 views1 answer
Vb net check if file exists
VBA
0 vote216 views1 answer
Get current year vb
VBA
0 vote244 views1 answer
Iterate all file in a folder vba
VBA
-1 vote248 views1 answer
Vba sendkeys
VBA
0 vote226 views1 answer
Vba compare strings
VBA
0 vote231 views1 answer
Excel vba Column Name to Column Number
VBA

Share