/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

2 votes286 views1 answer
Vba round number
VBA
0 vote255 views1 answer
Amd64 vs arm64 linux
VBA
0 vote235 views1 answer
Vb run command
VBA
0 vote244 views1 answer
Vbnet click on dgv cells
VBA
0 vote248 views1 answer
Windows Forms dark title bar
VBA
0 vote235 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote280 views1 answer
How to call gcd in vba
VBA
1 vote230 views1 answer
Excel vba first and last row and column in range
VBA
0 vote228 views1 answer
Vba get application version
VBA
0 vote228 views1 answer
Vbs write file
VBA