/VBA/Excel vba check if a string only contains alpha characters

Excel vba check if a string only contains alpha characters

'VBA function to test if a string contains only letters:

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

Source: academy.excelhero.com

Similar codes

0 vote233 views1 answer
Change whcih control a user has selected vb
VBA
1 vote230 views1 answer
Close form vba
VBA
0 vote238 views1 answer
Hello world vb.net
VBA
0 vote246 views1 answer
Vba check if class implements interface
VBA
0 vote248 views1 answer
Excel vba disable screen update
VBA
0 vote262 views1 answer
Vba search string position
VBA
1 vote238 views1 answer
Add control vb
VBA
0 vote207 views1 answer
Excel vba linter
VBA
0 vote223 views1 answer
Create new worksheet excel visual basic
VBA
0 vote260 views1 answer
Columns dont autoresize on program start vb.net
VBA