/VBA/Excel vba check if a string only contains letters

Excel vba check if a string only contains letters

'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 vote270 views1 answer
Tester si une case est vide vba
VBA
0 vote243 views1 answer
Not allow form to be resized
VBA
0 vote240 views2 answers
Excel vba protect cells with formula
VBA
3 votes247 views1 answer
Excel insert blank row for value change in column
VBA
0 vote245 views1 answer
Vba min
VBA
0 vote254 views1 answer
Vba find last column in a row with data
VBA
8 votes287 views1 answer
Vba make a short integer from two bytes
VBA
0 vote261 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote234 views1 answer
Vbs
VBA
0 vote258 views1 answer
Vba parameter adodb null value
VBA