/VBA/Excel vba check if a string only contains alpha characters

Excel vba check if a string only contains alpha characters

'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 vote208 views1 answer
VBA Loop to range
VBA
1 vote219 views1 answer
How to put a gridpain in a vbox
VBA
0 vote215 views1 answer
Vba code for cutoff time
VBA
0 vote239 views1 answer
Vbnet check if string is only letters
VBA
0 vote214 views1 answer
Set column width of datagridview vb.net
VBA
0 vote214 views1 answer
Excel vba unlock sheet without password
VBA
0 vote202 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote228 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote215 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote215 views1 answer
Excel vba protect worksheet without password
VBA