/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 vote155 views1 answer
Remove first character from string vb
VBA
0 vote153 views1 answer
Vba pass named range to function
VBA
0 vote137 views1 answer
Style percent not found vba
VBA
1 vote157 views2 answers
Vba string length
VBA
1 vote152 views1 answer
Vba refresh pivot table
VBA
0 vote142 views1 answer
Excel vba disable screen update
VBA
0 vote149 views1 answer
Hello world vb.net
VBA
0 vote152 views1 answer
Vbs
VBA
0 vote145 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote156 views1 answer
How to mount floppy disks in vb.net
VBA