/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 vote111 views1 answer
Excel vba to lower case
VBA
1 vote120 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote182 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote123 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote133 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote116 views1 answer
Vba file size
VBA
0 vote120 views1 answer
Vba border weight
VBA
0 vote151 views1 answer
Find control with name vb
VBA
1 vote66 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote118 views1 answer
Excel VBA web scraping
VBA

Share