/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 vote350 views1 answer
Le contrôle SpinButton (Toupie)
VBA
1 vote336 views1 answer
Excel vba hide zero values
VBA
8 votes427 views1 answer
Excel vba make integer
VBA
0 vote294 views1 answer
Vba code to remove leading and trailing spaces
VBA
5 votes437 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote343 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote373 views1 answer
How to extract a file from an ISO:
VBA
2 votes342 views1 answer
Vba uppercase first letter of each word
VBA
0 vote375 views1 answer
Vba keep command window open
VBA
1 vote374 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA