/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 vote283 views1 answer
Reset border color textbox vba
VBA
0 vote278 views1 answer
Vba format currency
VBA
0 vote286 views1 answer
Vba line feed
VBA
8 votes402 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote288 views1 answer
Vbscript Trim
VBA
0 vote295 views1 answer
Excel vba chrw max value
VBA
1 vote280 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote307 views1 answer
Excel vba protect sheet
VBA
0 vote321 views2 answers
Excel vba number format file size
VBA
0 vote287 views1 answer
Vba full date format
VBA