/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 vote243 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote239 views1 answer
Excel vba delete folder
VBA
5 votes217 views1 answer
Excel vba high word from Long Integer
VBA
0 vote226 views1 answer
Vba shape transparent
VBA
0 vote219 views1 answer
Vba argument is set
VBA
0 vote221 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote271 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote234 views1 answer
Vba delete file
VBA
0 vote242 views1 answer
How to use if condition in time vba
VBA
25 votes293 views2 answers
Excel vba folder exist
VBA