/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

5 votes165 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote146 views1 answer
Vba pass named range to function
VBA
8 votes197 views1 answer
Excel vba make word
VBA
0 vote139 views2 answers
Excel vba copy paste after last row
VBA
0 vote159 views1 answer
.net crash app
VBA
0 vote153 views1 answer
Excel vba automatic calculation
VBA
0 vote137 views1 answer
Vba text to general
VBA
0 vote152 views1 answer
Vba loop through textboxes
VBA
1 vote148 views1 answer
Vba date to unix timestamp
VBA
1 vote161 views1 answer
Vb.net get name by Cell Click
VBA