/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 vote218 views1 answer
Vba simple quote
VBA
0 vote202 views1 answer
Check range is in another range vba
VBA
1 vote2K views1 answer
Vba Remove Case Sensitivity
VBA
3 votes242 views2 answers
Vba date to string
VBA
1 vote202 views2 answers
Vba function return array
VBA
11 votes478 views1 answer
Excel vba How to URL encode a string
VBA
0 vote197 views1 answer
Vbnet add new ecel sheet
VBA
-1 vote240 views1 answer
Text to speech vb.net
VBA
0 vote215 views1 answer
How to format a textbox as date vb net
VBA
1 vote235 views1 answer
Perform http request in vb.net
VBA