/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 vote216 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote283 views1 answer
Vba excel do not recalculate before save
VBA
1 vote222 views1 answer
Random number generator vb.net
VBA
1 vote222 views1 answer
Excel vba close form escape key
VBA
0 vote232 views1 answer
Search combobox items vb.net
VBA
1 vote234 views1 answer
How to remove zeros in excel
VBA
0 vote211 views1 answer
Vba leading zeros in string
VBA
0 vote240 views1 answer
.net dark title bar
VBA
0 vote261 views1 answer
Excel vba round to whole number
VBA
-1 vote248 views1 answer
Vba sendkeys
VBA