/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 vote289 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote306 views1 answer
Excel R1C1 mode
VBA
8 votes368 views1 answer
Excel vba make integer
VBA
0 vote321 views1 answer
Vba add shape oval
VBA
0 vote303 views1 answer
Vba dropdown event
VBA
0 vote318 views2 answers
Vba remove line breaks
VBA
1 vote326 views1 answer
What does vbs stand for
VBA
0 vote317 views1 answer
Vba change named range address
VBA
0 vote303 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote346 views1 answer
Como ler subitem de um array em json usando vbnet
VBA

Share