/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 vote290 views1 answer
Excel vba join variant array
VBA
0 vote295 views1 answer
Send text to clipboard vb.net
VBA
-1 vote281 views1 answer
How to correct a number to 2 decimal places in vba
VBA
4 votes262 views1 answer
Excel vba how to reset usedrange
VBA
0 vote298 views1 answer
Vba collection contains
VBA
0 vote276 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote291 views1 answer
Vba html document reference
VBA
5 votes330 views1 answer
Excel vba get user selected range
VBA
0 vote279 views1 answer
Reset border color textbox vba
VBA
0 vote268 views1 answer
Excel vba formatconditions range
VBA