/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 vote165 views1 answer
Change form background image vb
VBA
0 vote130 views1 answer
How to sort datagridview in vb.net
VBA
0 vote175 views1 answer
Vba check 32 or 64 bit
VBA
0 vote172 views1 answer
Vbnet click on dgv cells
VBA
0 vote178 views1 answer
Enable macros on opening workbook vba
VBA
1 vote215 views1 answer
Perform http request in vb.net
VBA
4 votes209 views1 answer
VBA Deep Clone Dictionary
VBA
1 vote188 views1 answer
Add rows to datagridview vb.net
VBA
0 vote199 views1 answer
Visual basic cmd
VBA
0 vote186 views1 answer
Method showalldata of object _worksheet failed vba
VBA