/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 vote205 views1 answer
Vba cell all borders
VBA
0 vote171 views2 answers
Excel vba close without saving
VBA
8 votes228 views1 answer
Excel vba make word
VBA
0 vote190 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote180 views1 answer
Vbnet cycle through charaters in string
VBA
25 votes346 views3 answers
String to date vb
VBA
2 votes175 views1 answer
Excel vba date to string conversion
VBA
5 votes195 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote176 views1 answer
WGET FTP
VBA
0 vote175 views1 answer
Add Formula to Shape Text in VBA
VBA