/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 vote236 views1 answer
Vba type variable
VBA
0 vote236 views1 answer
Vba get application version
VBA
0 vote281 views1 answer
How to enter Vbox manage commands
VBA
0 vote228 views1 answer
Send webhook vbscript
VBA
0 vote240 views1 answer
Change form background image vb
VBA
6 votes246 views1 answer
Excel vba get the path of current workbook
VBA
1 vote234 views1 answer
Vba delete file
VBA
0 vote248 views2 answers
Vba remove line breaks
VBA
1 vote268 views1 answer
Excel vba first row in range
VBA
0 vote226 views1 answer
Vba add month to date
VBA