/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

25 votes309 views3 answers
String to date vb
VBA
0 vote179 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote161 views1 answer
Make your computer talk vbscript
VBA
0 vote170 views1 answer
VBA Sort RossetaCode
VBA
0 vote159 views1 answer
How to use if condition in time vba
VBA
0 vote151 views1 answer
Vba check 32 or 64 bit
VBA
5 votes172 views1 answer
Excel vba left word from Long Integer
VBA
0 vote178 views2 answers
Checking and changing system volume vb.net
VBA
2 votes157 views1 answer
Excel vba check if key is in collection
VBA
8 votes331 views1 answer
Excel vba make word from bytes
VBA