/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 vote309 views1 answer
Vba dictionary clear
VBA
0 vote328 views1 answer
Change form background image vb
VBA
4 votes317 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote331 views1 answer
Loop through each cell in dgv vbnet
VBA
-1 vote303 views1 answer
For i in range vba
VBA
0 vote322 views1 answer
Vbnet click on dgv cells
VBA
0 vote336 views2 answers
Get unique random number in vb.net
VBA
1 vote338 views1 answer
Random number generator vb.net
VBA
0 vote327 views1 answer
Excel vba ternary
VBA
0 vote317 views1 answer
Vba check if class implements interface
VBA