/VBA/Excel vba check if a string only contains letters

Excel vba check if a string only contains letters

'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

1 vote131 views1 answer
Random number generator vb.net
VBA
31 votes237 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote127 views1 answer
Vba array of integers
VBA
22 votes266 views1 answer
Xl vba check for folder
VBA
0 vote136 views1 answer
Excel vba StartUpPosition
VBA
8 votes210 views1 answer
Excel vba determine number of elements in a 2D array
VBA
1 vote119 views1 answer
Excel vba saveas force overwrite
VBA
1 vote124 views2 answers
Vba string to date
VBA
5 votes148 views1 answer
Excel-vba get integer high byte
VBA
1 vote136 views1 answer
Excel vba force recalculation
VBA