/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 vote265 views1 answer
Vb check if row has column
VBA
0 vote288 views1 answer
Vba open report
VBA
12 votes360 views1 answer
Excel vba write string to text file
VBA
0 vote269 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote281 views1 answer
Vba compare strings
VBA
0 vote266 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote287 views1 answer
Get month number from month name vbnet
VBA
22 votes446 views1 answer
Xl vba check for folder
VBA
1 vote261 views1 answer
Excel vba close form escape key
VBA
0 vote270 views1 answer
Vba shape transparent
VBA