/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 vote212 views1 answer
Vba apostrophe chr
VBA
5 votes227 views1 answer
Excel vba tool to help with refactoring code
VBA
4 votes195 views1 answer
Excel vba check cell not empty
VBA
0 vote199 views1 answer
Test if form is open vb
VBA
1 vote208 views1 answer
Excel vba to lower case
VBA
0 vote224 views1 answer
VBA
VBA
0 vote198 views1 answer
Excel vba center userform
VBA
1 vote229 views1 answer
Vb.net get name by Cell Click
VBA
0 vote211 views1 answer
Excel vba combine ranges
VBA
5 votes226 views2 answers
Excel vba write to the windows registry
VBA