[Solved] Excel Vba Check If String Entirely Alpha | Vb - Code Explorer

[Solved] Excel Vba Check If String Entirely Alpha | Vb - Code Explorer | yomemimo.com

Question : excel vba check if string entirely alpha

Answered by : daniel-ferry

'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

Source : http://academy.excelhero.com/ | Last Update : Thu, 07 May 20

Question : excel vba check if a string only contains alpha characters

Answered by : daniel-ferry

'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 : http://academy.excelhero.com/ | Last Update : Sun, 30 Aug 20

yomemimo.com