/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 vote331 views1 answer
Excel vba disable copy paste
VBA
1 vote348 views1 answer
Add control vb
VBA
0 vote370 views1 answer
Excel filter by date not working vba
VBA
0 vote333 views1 answer
Excel vba disable alerts
VBA
0 vote344 views1 answer
Excel vba disable keyboard input
VBA
2 votes378 views2 answers
Excel vba if sunday or staurday
VBA
1 vote364 views1 answer
Excel vba first row in range
VBA
0 vote326 views1 answer
Check if program is running vbnet
VBA
1 vote300 views1 answer
Vba Remove Case Sensitivity
VBA
2 votes332 views1 answer
Date format for ms chart vb.net
VBA