/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 vote288 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote303 views1 answer
Excel vba protect sheet
VBA
0 vote274 views1 answer
Vba format currency
VBA
0 vote286 views1 answer
Priavte sub with multiple handels find sneder
VBA
-1 vote270 views1 answer
Text to speech vb.net
VBA
0 vote305 views1 answer
Vba find last column in a row with data
VBA
0 vote301 views1 answer
Excel vba prevent saving workbook
VBA
0 vote282 views1 answer
Search in richtextbox vb.net
VBA
0 vote296 views1 answer
Excel vba unlock sheet without password
VBA
8 votes317 views1 answer
Excel vba make a short integer from two bytes
VBA