/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 vote256 views1 answer
Excel vba combine ranges
VBA
0 vote226 views1 answer
Vba add month to date
VBA
3 votes242 views1 answer
Vba make long from two words
VBA
0 vote226 views1 answer
Vba remove numbers from string
VBA
0 vote253 views1 answer
Vbnet click on dgv cells
VBA
0 vote229 views1 answer
Excel vba remove formatting from cell
VBA
0 vote236 views1 answer
Vbs send keys
VBA
0 vote248 views1 answer
Vbs run with cscript
VBA
0 vote242 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote231 views1 answer
Quit excel with save changes dialog vb.net
VBA