/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

1 vote219 views1 answer
Excel vba last row of range
VBA
2 votes153 views2 answers
Vba exit loop
VBA
0 vote204 views1 answer
Vba parameter adodb null value
VBA
3 votes242 views1 answer
Extract word in a text in excel
VBA
0 vote233 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote224 views1 answer
Vba listbox remove all items
VBA
11 votes478 views1 answer
Excel vba How to URL encode a string
VBA
0 vote227 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote213 views1 answer
Compare dates vb
VBA
1 vote220 views1 answer
Export datagridview to excel vb.net
VBA