/VBA/Excel vba check if string entirely alpha

Excel vba check if string entirely alpha

Excel vba check if string entirely alpha

'VBA function to check if string is ENTIRELY alpha:

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

2

Source: academy.excelhero.com

Similar codes

1 vote145 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote156 views1 answer
Find database connection string vb
VBA
3 votes151 views1 answer
Excel insert blank row for value change in column
VBA
31 votes273 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote146 views1 answer
Vbscript for loop
VBA
1 vote158 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote141 views1 answer
Excel vba center userform
VBA
6 votes163 views1 answer
Excel vba get the path of current workbook
VBA
0 vote148 views1 answer
Group controls programmatically vb
VBA
0 vote147 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA

Share