/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 vote162 views1 answer
.net dark title bar
VBA
0 vote162 views1 answer
Vba extract filename from path
VBA
0 vote145 views2 answers
Excel vba copy paste after last row
VBA
0 vote150 views1 answer
Vb get ip address
VBA
0 vote157 views1 answer
Excel vba delete folder
VBA
1 vote170 views1 answer
How to remove zeros in excel
VBA
1 vote152 views2 answers
Vba string to date
VBA
25 votes298 views2 answers
Excel vba folder exist
VBA
1 vote155 views1 answer
Highlight selected cell in excel vba
VBA
0 vote159 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA