/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 vote342 views1 answer
Vba compile error object required
VBA
2 votes340 views2 answers
Constructor vb.net
VBA
0 vote348 views1 answer
Vbnet line graph smooth lines
VBA
1 vote396 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote365 views1 answer
Vba html document reference
VBA
0 vote355 views1 answer
Vba leading zeros in string
VBA
0 vote324 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote386 views1 answer
Open file dialog in vb.net
VBA
0 vote332 views1 answer
Excel vba existence of a file
VBA
1 vote437 views1 answer
Excel vba convert text YYYYMMDD to date
VBA

Share