/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

8 votes234 views1 answer
Run command pormpt in background windows
VBA
0 vote214 views1 answer
Vbnet get file name from path
VBA
0 vote240 views1 answer
Vbs exec hidden
VBA
0 vote241 views1 answer
Vba random number
VBA
0 vote227 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote213 views1 answer
Check if program is running vbnet
VBA
1 vote243 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote236 views1 answer
Group controls programmatically vb
VBA
0 vote235 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote219 views1 answer
Return na vba
VBA