/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

0 vote224 views1 answer
Vbnet get file name from path
VBA
-1 vote232 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote233 views1 answer
Vba first cell in range
VBA
5 votes261 views1 answer
Excel vba first byte from INTEGER
VBA
8 votes266 views1 answer
Excel vba make integer
VBA
3 votes296 views2 answers
Excel "vba" match last value
VBA
0 vote230 views1 answer
Excel vba populate array with cell values
VBA
2 votes297 views1 answer
Vba round number
VBA
0 vote220 views1 answer
Backspace key has stopped working visual studio
VBA
1 vote248 views2 answers
Vba string length
VBA