/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

1 vote175 views1 answer
Vba exit do while
VBA
0 vote233 views1 answer
Add text to Shape VBA
VBA
0 vote222 views1 answer
Vba sheet visible
VBA
0 vote220 views1 answer
Vba DisplayGridlines
VBA
0 vote235 views1 answer
Set datetimepicker value to null vb
VBA
0 vote279 views1 answer
Vba vbcrlf chr
VBA
-1 vote206 views2 answers
How close excel through visual basic
VBA
0 vote227 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote221 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote212 views1 answer
Excel vba range contains
VBA