/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 vote132 views1 answer
Vba open report
VBA
0 vote120 views1 answer
Excel vba address not absolute
VBA
0 vote114 views1 answer
Excel vba clear filter
VBA
0 vote139 views1 answer
Wpf dark title bar
VBA
0 vote121 views1 answer
Excel vba assign shortcut key to button
VBA
22 votes164 views1 answer
Excelvba check for directory
VBA
1 vote124 views1 answer
Vba ubound array 2-dimensional
VBA
5 votes131 views1 answer
Excel vba low word from Long Integer
VBA
0 vote126 views1 answer
Search combobox items vb.net
VBA
0 vote131 views1 answer
VBA Sleep Snippet
VBA