/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 vote355 views1 answer
Remove series name from legendvbnet
VBA
1 vote351 views1 answer
Add a index column power bi
VBA
25 votes532 views3 answers
String to date vb
VBA
0 vote338 views1 answer
Enter into cells data grid view
VBA
0 vote376 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote384 views1 answer
Vba variable number of arguments
VBA
0 vote420 views1 answer
Excel vba protect scenarios
VBA
0 vote370 views1 answer
Arq linux
VBA
0 vote293 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote376 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA