/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 vote162 views1 answer
Vba pass named range to function
VBA
0 vote168 views1 answer
Create links in msgbox in vb
VBA
0 vote182 views1 answer
Excel vba first column in range
VBA
0 vote153 views1 answer
Change whcih control a user has selected vb
VBA
22 votes304 views1 answer
Excelvba check for directory
VBA
0 vote163 views1 answer
Vba collection contains
VBA
1 vote168 views1 answer
Set font for ms chart vb.net
VBA
0 vote154 views1 answer
Enter into cells data grid view
VBA
0 vote239 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote155 views1 answer
Excel vba formatconditions positive
VBA

Share