/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 vote271 views1 answer
Vba first line of string
VBA
0 vote273 views1 answer
Do until vb.net
VBA
-1 vote319 views1 answer
Code for reading letters only in vb 6
VBA
0 vote299 views1 answer
Selecttoken em vbnet e json
VBA
0 vote279 views1 answer
Excel vba disable mouse click
VBA
1 vote265 views1 answer
Vba listindex select multiple items vba
VBA
1 vote290 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote330 views1 answer
Visual basic run command
VBA
0 vote294 views1 answer
Excel vba textbox forecolor disabled
VBA
1 vote336 views1 answer
Perform http request in vb.net
VBA