/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

0 vote171 views1 answer
Remove last 8 characters from string vb
VBA
0 vote168 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote188 views1 answer
.net crash app
VBA
0 vote187 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote194 views1 answer
Excel vba DisplayAlerts
VBA
0 vote183 views1 answer
Vba keep command window open
VBA
1 vote172 views2 answers
Vba find last row in range for certain criteria
VBA
1 vote172 views1 answer
Excel vba to lower case
VBA
0 vote190 views1 answer
VBA
VBA
0 vote177 views1 answer
Convert unix to date vba
VBA