/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 vote138 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote143 views1 answer
Date as number vb
VBA
0 vote135 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote127 views1 answer
Vba remove numbers from string
VBA
1 vote136 views1 answer
Set font for ms chart vb.net
VBA
0 vote139 views1 answer
Vba min
VBA
0 vote130 views1 answer
Excel vba calculate
VBA
7 votes152 views1 answer
Excerl vba array to range
VBA
0 vote127 views1 answer
Excel vba chrw max value
VBA
0 vote137 views1 answer
.net dark title bar
VBA