/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 vote364 views1 answer
Send webhook vbscript
VBA
0 vote355 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote379 views1 answer
Vba parameter adodb null value
VBA
0 vote402 views1 answer
Vba nested dictionary
VBA
0 vote374 views1 answer
Vba registry settings
VBA
0 vote359 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote350 views1 answer
Vb.net change cursor to wait
VBA
0 vote348 views1 answer
Vbscript check if string is empty
VBA
1 vote335 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote403 views1 answer
Vbs run with cscript
VBA