/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 vote193 views1 answer
Make all controls in an area not visable vb
VBA
0 vote206 views1 answer
Write listbox to text file vb.net
VBA
7 votes191 views1 answer
Vba array declaration
VBA
0 vote198 views1 answer
Telephon call in vba
VBA
1 vote207 views1 answer
What does vbs stand for
VBA
1 vote201 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
3 votes202 views1 answer
Excel insert blank row for value change in column
VBA
4 votes200 views1 answer
Vba create directory
VBA
0 vote203 views1 answer
Vba is integer
VBA
0 vote219 views1 answer
Vba boolean to string
VBA