/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 vote172 views1 answer
Sort dictionary by key vba
VBA
5 votes165 views1 answer
Excel vba high word from Long Integer
VBA
1 vote123 views1 answer
How to open cmd with vbd
VBA
0 vote202 views1 answer
Vbnet check if string is only letters
VBA
0 vote182 views1 answer
Vba clear collection
VBA
0 vote195 views1 answer
Create new worksheet excel visual basic
VBA
0 vote170 views1 answer
Vba array dimensions
VBA
1 vote175 views1 answer
Excel vba array remove first
VBA
1 vote180 views1 answer
How to remove zeros in excel
VBA
0 vote172 views1 answer
Vba type variable
VBA