/VBA/Excel vba check if a string only contains alpha characters

Excel vba check if a string only contains alpha characters

'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

4 votes92 views2 answers
Vba last row
VBA
0 vote74 views1 answer
How to sort datagridview in vb.net
VBA
0 vote115 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote124 views1 answer
Excel vba formatconditions positive
VBA
0 vote107 views1 answer
Excel vba concatenate range
VBA
0 vote120 views1 answer
Remove frist letter from string vbnet
VBA
0 vote125 views1 answer
Vba format currency
VBA
1 vote116 views2 answers
Excel vba password protect
VBA
1 vote120 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
2 votes109 views1 answer
Excel vba extract file name
VBA