/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 vote322 views1 answer
Excel vba chrw max value
VBA
0 vote310 views1 answer
Excel vba address not absolute
VBA
0 vote331 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote329 views1 answer
Vba remove last vbcrlf
VBA
0 vote343 views1 answer
Vba count all row
VBA
0 vote309 views1 answer
Vbscript check if string contains
VBA
0 vote342 views1 answer
Excel vba add reference programmatically
VBA
5 votes327 views1 answer
Xl vba double quotes in string literal
VBA
0 vote325 views1 answer
Vba round to 2 decimals
VBA
0 vote322 views1 answer
Vba get relative cell address
VBA