/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

1 vote243 views1 answer
Set font for ms chart vb.net
VBA
0 vote228 views1 answer
Vba find sub dictionary
VBA
0 vote235 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote269 views1 answer
Vba ternary
VBA
0 vote293 views1 answer
Excel vba protect worksheet without password
VBA
0 vote243 views1 answer
Open file dialog in vb.net
VBA
0 vote238 views1 answer
Vba count all row
VBA
0 vote256 views1 answer
Excel R1C1 mode
VBA
0 vote232 views1 answer
Find days in month vba
VBA
0 vote266 views1 answer
Vbnet cycle through charaters in string
VBA